[RESOLVED] MS SQL query to MySQL

[dwalter]

hey everyone,

I need this query converted from MS SQL to MySQL,

select MaxDate=max(convert(char(8),createdate,1))
FROM IPTHeader
Where hshipto = '19'

basically what I'm trying to do is to get is 1 record which should be the most recent createdate. Also I need the date fromat changed from 2007-12-11 00:00:00.000 to 2007-12-11. The code above works when ran against a MS SQL database, but not against my MySQL. Any help would be greatly appreciated. Also is there any software out there that will translate between SQL dialects? I found SwissSQL, but it is very expensive. I'm looking for something more in the free-$60 US range.

Thanks,

Dylan

[bradgrafelman]

If you're simply trying to find the record with the most recent createdate....

SELECT col1, col2 FROM myTable ORDER BY createdate DESC LIMIT 1

[dwalter]

thanks alot