Datasys Knowledge Base Document |
Knowledge Base index |
Updated: | 2002/01/23 |
Product: | FaxChange |
Version: | no dependency |
Service pack: | no dependency |
Area: | Database |
Category: | TIP |
Problem: | Date export from tFile database |
Problem description:
Date and time of fax sending is stored in database in UNIX format, i.e. number of seconds since 1.1.1970. If you need to work with this date in other applications, you must convert it.
Solution:
Conversion can be done by simple script - example for VB follows:
' fill 't' variable by date to be converted
t = 1013691475
t = t/86400
t = DateSerial( 1970, 1, 1 ) + t
After execution of this script 't' variable contains date/time according GMT - you must add time difference from GMT to location where Faxchange runs.
Further information:
--
Keywords:
FaxChange,Database,Export
If there is something unclear, send us an email to development@datasys.cz.