imsleepy

Somehow this 1091654809 translates to this Wed 04 Aug 2004 17:26:49 EDT

I need to change a few dates in my database. Usually this is not a problem... but when it looks like that... it's a BIG problem. If I can figure out the "code" then I can make the changes I need to make.

I need to put the actual date the articles were written... not the date they are posted to the site. For the most part, I have been able to just go in the database and change a "real" date.

But there is one section that has this weird number thing going on. Some of the dates I need to change to go back to 1999.

If anyone can shed some light on this I sure would appreciate it. Maybe there is some sort of table somewhere??? I searched and searched Yahoo, but Yahoo doesn't seem to understand what I am asking it to look for. My guess is there is some technical name for what I need... but I don't know what it is...

Thanks.

bassdaddy777

I believe computers don't actually know the time and date. Instead they count how many seconds have passed since a certain event. How you can convert that I don't know.

__________________
Bronze Reseller
Pass36

Travis

I think it it counts from january 1st 1990

__________________
"A lot of people are waiting for Martin Luther King or Mahatma Gandhi to come back -- but they are gone. We are it. It is up to us. It is up to you."
— Marian Wright Edelman

klasiphyd

Yeah it's Unix time. Here is an easy online conversion page http://www.onlineconversion.com/unix_time.htm

__________________
The early bird may get the worm, but the second mouse gets the cheese.
.:. Sync .:. OC5 .:.

klasiphyd

Actually I think it's seconds since 01.01.1970

EDIT: yep, looking at that link I posted a little closer it says so right on it. (what? read a webpage instead of just using it? naw..)

__________________
The early bird may get the worm, but the second mouse gets the cheese.
.:. Sync .:. OC5 .:.

imsleepy

Thanks! Perfect!! :reddance: