Posted by Desert Rider on 10/21/06 21:30

Unfortunately my data from the previous entries does not have
timestamps available, only month, day, year and TOD (24 hr). I really
need something that allows me to enter a date and time e.g. 4/21/2003
23:25 and then returns the proper timestamp in seconds since
01/01/1970. I could then enter that in the date>value field and it
would put that date/time on the entry. I've done some googleing and
have found various references to programming that will do that but way
beyond my expertise. Even if I could find something that would
accurately give me the amount of days say between 01/01/1970 and say
4/21/2003 I could then compute the seconds and then add the additional
time for that day. Alas, I'm numeracy challanged and so require
something pretty simple.

peter wrote:
> > 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.

[Back to original message]