Dates in MySQL

[1337-Dev]

Will something like:

$date = date(whatever);

$sql  = mysql_query("INSERT INTO blah VALUES '$date'"); 

Insert the current date of the insert into the database?

[pentium10]

Probably this will help you!

CREATE TABLE blah (
  id int(11) NOT NULL auto_increment,
  date datetime NOT NULL default '2004-01-01 00:00:00',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

mysql_query("INSERT INTO blah VALUES ('', NOW( ) );"); 

[1337-Dev]

I dont really wanna re-create the database as i have loads of work to be done..i jsut want to know the correct format to inset a date into a database .

[someonewhois]

Use timestamp format. Int 15.

[1337-Dev]

Cheers

[WellBaffled]

Will something like:

$date = date(whatever);

$sql  = mysql_query("INSERT INTO blah VALUES '$date'"); 

Insert the current date of the insert into the database?

Sure it will, but dependant upon the column type in MySQL.