Date format in linked History.dbf

Use this forum to post questions relating to WinGate, feature requests, technical or configuration problems

Moderator: Qbik Staff

Date format in linked History.dbf

Postby Hamish » Mar 17 04 1:44 am

I've linked the history.dbf file into MS Access 97.

Although all the other fields are fine, I can't seem to get the date field to view correctly.

For example in the text export of the history file one line reads "16-Mar 12:34:09" but in the history.dbf file it is showing up as "1079440449".

Does anyone know how I can view the date field correctly using MS Access 97?
Hamish
 
Posts: 3
Joined: Mar 17 04 12:57 am

Postby Pascal » Mar 17 04 11:18 am

The date is worked out as the number of seconds since midnight, January 1, 1970. (Standard C time_t) You'll need to use an appropriate conversion / format to convert it.
Pascal

Qbik New Zealand
pascalv@qbik.com
http://www.qbik.com
Pascal
Qbik Staff
 
Posts: 2623
Joined: Sep 08 03 8:19 pm
Location: Auckland, New Zealand


Return to WinGate

Who is online

Users browsing this forum: No registered users and 14 guests

cron