Page 1 of 1

TODAY()

Posted: Fri Jul 09, 2010 8:18 pm
by paul3648
I am trying to alter some code that reads one database, then inserts the reformatted data into another database.

One line of this code reads:

$cart->due_date = TODAY();

This inserts today's date into the new database as : 2010-07-09

But if I change the line to read:

$cart->due_date = "2010-07-09";

no data is inserted.

Can someone help me understand the format of TODAY() and why I can't exchange it with "2010-07-09"

Re: TODAY()

Posted: Fri Jul 09, 2010 8:44 pm
by paul3648
It's OK - I got the answer...

TODAY() is formatted as 07/09/2010