incorrect time :S

[alexgeek]

I get a mysql error when inserting the variable time with value time() saying that it's the incorrect format.
the column is called timestamp and is type timestamp with default current timestamp

[alexgeek]

oh i think i need to use integer for the type..

[Rakuli]

Mysql timestamps are completely different to PHP time.

PHP uses unix timestamps - num of seconds since the epoch.

MYsql timestamps have the format

'YYYY-MM-DD HH:mm:SS'

mySQL can work with a much larger date range then PHP.

I find that making a column with an integer value works for simple logging via PHP.

Cheers,

[alexgeek]

Originally Posted by Rakuli

Mysql timestamps are completely different to PHP time.

PHP uses unix timestamps - num of seconds since the epoch.

MYsql timestamps have the format

'YYYY-MM-DD HH:mm:SS'

mySQL can work with a much larger date range then PHP.

I find that making a column with an integer value works for simple logging via PHP.

Cheers,

yeah that's what i did
gotta find my code to convert it to a date now

[alexgeek]

PHP: Select all

date("d/m/Y", $var);