Unless you have a good reason for doing it this way round, I suggest you would be better off using the database's own date function. Pretty much any db will have TODAY() or DATE()
type functions. Advantages-

a) They will emit the data in the right format, in fact you can just insert the function
    straight into the update command.

b) You have one notion of time, the database server's. You may have everything on one machine today, but tomorrow you might move the RDBMS to it's own server, and then you have the opportunity for clocks being out of sync. If you always use the
    clock time from the db server you have one reference.

Regards: Colin

"Ron Piggott" <[EMAIL PROTECTED]>
Fri, 9 Sep 2005 12:52:59 -0500
"PHP DB" <>

"PHP DB" <>


I am trying to for the first time create a table with a column that is
defined as datetime

I wanted to populate that column with the date(r) command.

date(r) on my web site gives this response:

Fri, 9 Sep 2005 13:32:19 -0400

How may I manipulate date(r) to give a format which is compatable to the
column type

0000-00-00 00:00:00
YYYY-MM-DD 24:59:59


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to