Datetime

[Sharif]

Anyone ever use a function called now() to get the date and time to insert into a datetime field?

[LordShryku]

Sure....

mysql> SELECT NOW();
        -> '2003-11-11 17:50:26'

[Sharif]

No a php function, not a mysql one.

[LordShryku]

There's no such function. It would have to be custom

[Sharif]

So what's the best way of inserting into a datetime field?

[tekky]

Originally posted by Sharif
So what's the best way of inserting into a datetime field?

$dtime = date('Y-m-d G:i:s');
$result = mysql_query("insert into table ('datetimecolumn') values ('$dtime');

like that maybe?

or if you plan on using the current time/date....

INSERT INTO table ('datetimecolumn') values (now());

or...

function now()
{
     return date('Y-m-d G:i:s');
}