[thelist] date time query

[Mark Groen]

----- Original Message ----- 
Sent: July 28, 2004 10:20 PM
Subject: RE: [thelist] date time query


> > 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?
>
> Mark,
>
> Hmmm... which database would this be?  One thing to look at would
be the
> CONCAT function.  If you are concatenating the strings with the +
operator,
> I don't see why you'd need the CONCAT method.  Perhaps it should be
> CONCAT(postdate, ' ', time)?  I think you are using MySQL, and I'm
not a
> MySQL guru, but do check that you can implicitly convert between
date and
> time types to string, and back from a string to datetime
automatically like
> this.

Hope you're not right that it might be a limitation of MySQL, seems
so simple... will check.

tia!

cheers,

       Mark