On Mon, 24 Aug 2009 13:19:33 -0400 "Nancy Wichmann" <[email protected]> wrote:
> >From looking at the PG docs, I see that "DATE( FROM_UNIXTIME( > r.timestamp ) ) AS 'date'" probably needs to be changed to > "CAST(r.timestamp AS date) AS 'date'" and I can do that in my > code. The funny thing is that the MySql docs mention doing the > same, but it returns a NULL. postgresql has to_timestamp(double precision) from 8.1 but it doesn't seem it is supported by mysql. I think it is better you convert the date on the php side. pg uses " to quote identifiers and alias. Other than that I've no site that really use revisions to really test your sql. Other than that it ran without errors. -- Ivan Sergio Borgonovo http://www.webthatworks.it
