Date functions

[Hayden Kirk]

Ok

This is really anoying me...

I am using a timestamp colum in my MySQL table, I generate a timestamp with
php using time(); When I pull the time from the table I get some date from
the 1970's... does anyone know whats going on? Im using the date() function
to display the timestamp.

Thanks

[Tom Thackrey]

On 19-Mar-2004, "Hayden Kirk" <sp**@spam.com> wrote:

I am using a timestamp colum in my MySQL table, I generate a timestamp
with
php using time(); When I pull the time from the table I get some date from
the 1970's... does anyone know whats going on? Im using the date()
function
to display the timestamp.

Without seeing your code I would guess that you are inserting the time()
directly into the timestamp column. This won't work because mysql is not
expecting a unix timestamp. Change the column type to int or insert a proper
mysql time.

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)

[Hayden Kirk]

Ah ok

That is the problem

What is the mysql time format? I thought it was a unix time stamp?

Could I get a breif example please...

I know this is a linux n00b question... but why do dates start at 1970?

Thanks

"Tom Thackrey" <us***********@nospam.com> wrote in message
news:J8*******************@newssvr29.news.prodigy. com...

On 19-Mar-2004, "Hayden Kirk" <sp**@spam.com> wrote:

I am using a timestamp colum in my MySQL table, I generate a timestamp
with
php using time(); When I pull the time from the table I get some date from the 1970's... does anyone know whats going on? Im using the date()
function
to display the timestamp.
Without seeing your code I would guess that you are inserting the time()
directly into the timestamp column. This won't work because mysql is not
expecting a unix timestamp. Change the column type to int or insert a

proper mysql time.

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)

[Tom Thackrey]

On 19-Mar-2004, "Hayden Kirk" <sp**@spam.com> wrote:

What is the mysql time format? I thought it was a unix time stamp?

The manual is your friend:
http://www.mysql.com/doc/en/Date_and_time_types.html

Could I get a breif example please...
'2004-03-19 12:00:00'

I know this is a linux n00b question... but why do dates start at 1970?

The Unix timestamp was the system time on the original Unix systems. There
was no need for dates prior to 1970, so it was defined as the number of
seconds since Jan 1, 1970.

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)