[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