Trying to manually change entry dates in my DB... Help !

The date field is using an 11 digit INT.
One of my dates has a value of '1152951014' which equals Saturday, July 15, 2006 03:10 AM.

Is this field in milliseconds? And if so, what's the starting date it uses?
I need to change all my dates back about 2 years, and I'm sort of stuck.

Thanks for any help.

no. of milliseconds since the epoch - 1900 (or was it 1901?) Jan. 1st something like 12 midnight. Google epoch.

Number of seconds since midnight January 1st 1970 I believe. Or rather at 1 second past midnight on the morning on January 1 1970 the timestamp would of been 1.

Seconds? I thought it was milliseconds?

But then thinking about it seconds would be easier to store ; )
You'd run out of space with milliseconds.

Thanks for clearing that up Carb.

Well there are 86400000 milliseconds in the day so yeah would soon be needing really long numbers.

Carbonize wrote:Well there are 86400000 milliseconds in the day so yeah would soon be needing really long numbers.

lol.

In relation to the orginal question to change it back by 2 years its that number minus - 2 x 365 x 24 x 60 x 60.