|
Posted by peter on 10/21/06 20:09
> Thanks for the reply. Sounds like I'll get a chance to utilize my
> limited computational skills. Unless...is there a reference guide or
> table anywhere that lists yearly totals since 1970? That would get me
> close and then I could compute the additional seconds for a given
> month, day and time.
you can easily convert the timestamp to the date using something like:-
SELECT FROM_UNIXTIME( 1161408341 )
you can use that function in a select query when retrieving data as well.
Navigation:
[Reply to this message]
|