Need help inserting current timestamp into mysql

theMAD2 · 8 Aug 2006 at 10:39

I've got a table with a field TIMESTAMP, but I've tried everything I can think of and still can't get the current timestamp in there. I'm using php to insert the data, should I be using php to generate the time and date then insert the numbers, or should I use timestamp with default to CURRENT_TIMESTAMP in mysql?

Thanks

JonD · 8 Aug 2006 at 10:42

I use a int(10) to hold the unix timestamp for a date.

$date = time();

$query = "INSERT INTO TABLE_NAME `date` = '".$date."'...

Then by using PHP to get the date back.

theMAD2 · 8 Aug 2006 at 10:44

Sorry mate, no joy. The date field is a timestamp at the moment, should I be using datetime? When I'm printing it back I'm just getting 0000-00-00 00:00:00 s

theMAD2 · 8 Aug 2006 at 10:57

Thanks for your help, I managed to sort it in the end by inserting $date in this:

Code:

$date = date('Y-m-d H:i:s');

into a datetime field.

Beansprout · 8 Aug 2006 at 12:06

NOW()

theMAD2 · 8 Aug 2006 at 12:08

Beansprout said:
NOW()

I tried that and it didn't seem to work. Do you put that in the default value?

Beansprout · 8 Aug 2006 at 12:23

theMAD2 said:
I tried that and it didn't seem to work. Do you put that in the default value?

INSERT INTO foo(hello,thedate) VALUES("bar",NOW());

Something like that anyway