UTC Time conversion within sybase
Posted on 2009-04-20
I am trying to convert a normal time that is stored in sybase to UTC time and back.
Reason: In my compnay, there are 2 tables, one table stores the time in UTC and I have to compare that to another time in another table which is NOT stored in UTC time, hence, there was time differences between the two table.
My current solution was to take one time, subtract 4 compare to the other table and then add back 4. But apparently I cant do that because of daylitght savings.
So ultimately my question is, is there a way to manipulate UTC time and normal time in sybase, thanks.