Posted by Desert Rider on 10/21/06 19:58

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.

J.O. Aho wrote:
> Desert Rider wrote:
> > My apologies for the length of this post but I'm hoping that some
> > background will help clarify my request. I'm not using MySQL for
> > anything other then the database for my guestbook. I had a previous
> > guestbook that became corrupted and my new guestbook uses MySQL. I have
> > access to the database via phpMyAdmin and I can display the entry data
> > fields.
> >
> > What I am doing is taking the entries from my previous guestbook and
> > entering them into the new guestbook. The problem is that the date and
> > time entry is the current time and date and I want it to be the time
> > and date of the original entry. When I view the datetime field in
> > phpMyAdmin the value is listed as a numerical value that, at least to
> > me, does not correlate to a month, day, year and time value. Example: A
> > 10/20/2006 11:25 pm entry shows up as 1161408341 in the date>value
> > field in phpMyAdmin.
> >
> > Is there a correlation table or some sort of formula that I can use to
> > alter the entered date>value number to the date and time that I want?
>
> It's seconds since 00:00 January 1, 1970.
>
> 00:01 January 1, 1970 = 1
> 00:00 January 2, 1970 = 86400
> and so on to 2038 when the signed 32 bit value will have reached it's largest
> value (as there are a few years until then, we will see 64 bit to be used for
> unix time, but sadly this will lead to trouble with some closed sourced
> programs in the same manner as all the old ms-dos/ms-windows programs got at 2k).
>
>
> //Aho

[Back to original message]