what is wrong with this sql query? he is crying on NOW() :(
("INSERT INTO " . PREFIX . "messages (from, to, title, message, date)
VALUES (" . $from . ", " . $to . ", " . $subject . ", " . $message . ", NOW())");
views:
70answers:
2
+2
A:
Are you using MySQL or Microsoft SQL Server? NOW() doesn't work in SQL Server; need to use GETDATE() instead.
Scott
2010-02-25 15:45:48
`GETDATE()` is SQL Server specific - this question is for **MySQL**. `CURRENT_TIMESTAMP` is ANSI standard however, supported on both.
OMG Ponies
2010-02-25 15:48:20
@Scott: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now ?
Adam Kiss
2010-02-25 15:49:30
Woops, I've been trapped in the SQL Server world for too long.
Scott
2010-02-25 16:11:03
FYI: the original question did not specify SQL or MySQL
David Radcliffe
2010-02-25 16:39:15