Convert a Date to a String in Sqlite

Posted by Billy on Stack Overflow See other posts from Stack Overflow or by Billy
Published on 2010-06-10T20:01:24Z Indexed on 2010/06/10 20:13 UTC
Read the original article Hit count: 315

Filed under:
|
|

Is there a way to convert a date to a string in Sqlite? For example I am trying to get the min date in Sqlite:

SELECT MIN(StartDate) AS MinDate FROM TableName

I know in SQL Server I would use the SQL below to accomplish what I am trying to do:

SELECT CONVERT(VARCHAR(10), MIN(StartDate), 101) AS MinDate FROM TableName

Thanks!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about tsql