EPOCH TIME 01-01-1970

[pantz]

Hi everybody,

Does anyone know how to get the well known EPOCH time in GFA 32 ?
I have to handle huge logfiles with the timestamp coded as EPOCH elapsed seconds, with time-window filtering.

So I have to switch from EPOCH to human readble time and date, end revert operation.

thanks
pascal

[pantz]

Finally I got it, through Cdate function because gfa use 1899 as epoch time.


Function DateToEpoch(horodatage$)
Local x, epoch, epochSecond As Double
epoch = CDate("jan 1 1970 00:00:00")
x = CDate(horodatage$)
epochSecond = (x - epoch) * 86400 // Given in local timezone, for others : need to add or remove the appropriate seconds
Return epochSecond
EndFunc