[thelist] date time query

Mark Groen mark at markgroen.com
Wed Jul 28 23:57:41 CDT 2004


I can't seem to get a query to work as expected:

INSERT INTO bowenonline (id, datestamp, thread, parent, author,
subject, email)
SELECT id, CONCAT(postdate + time) AS datestamp, thread, parent,
author, subject, email FROM forum;

The datestamp field gets populated with the default 0000-00-00
00:00:00 instead of something like 1999-01-01 12:01:01. The datestamp
field is a DATETIME type and the postdate is DATE and time is TIME.
Anything obvious I might be missing here?

cheers,

       Mark




More information about the thelist mailing list