Convert Date Function

As long as thats 'YYYY-MM-DD HH:MM:SS' the below should work fine.

SELECT CONVERT(DATETIME,'2013-01-01 00:00:00')

Select allOpen in new window

You aren't telling it what you want to convert to. ie:

select convert( date, IssueDate, 101 ) as convertedIssueDate from tblpermit;

Select allOpen in new window

Edit: You may have to play with this a bit, since I assumed you were trying to convert the value of what's in the IssueDate column, but after seeing EvilPostIt's take, i see it was kind of up in the air. (and 101's mm/dd/yyyy =)

select convert(varchar, IssueDate, 101) from tblpermit

There would be no difference between using the column name or the string. If the month is the other way round you may have to set the language.

select convert(varchar, IssueDate, 101) from tblpermit

returned

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar, PermitIssueDate, 101) from tblpermit' at line 1

getting the same error for all suggestions

So your using mySQL not SQL Server then...

Look at the DATE_FORMAT function

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

should have mentioned that, apoligies.

MySQL

Thank you