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.