Hi all..We have a DB here that uses this as a time format (god knows why)
Difference of the current date and time 1/1/1979 in seconds in GMT minus 5.
I know, crazy...I did not design this...As there a way for me to convert this on the query line? I searched for a data function that could accomplish this and I have the feeling there is one but I just can't seem to dig it up.
adds timeval (your seconds since 1/1/79) and then adds 5 hours. If this isnt quite right you can modify it quite easily. One minor point it isnt since 1/1/1970 is it as this quite commonly used a number of operating systems.