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
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