[thelist] date time query

[Mark Groen]

----- Original Message ----- 
From: "Hassan Schroeder" <>
To: <thelist at lists.evolt.org>
Sent: July 28, 2004 11:04 PM
Subject: Re: [thelist] date time query


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

> ... FROM_UNIXTIME(UNIX_TIMESTAMP(postdate) + TIME_TO_SEC(time)) AS
> datestamp, ...

That's it! Thanks Hassan, you're a star!

cheers,

       Mark