How can I convert datetime to date format in SQLite?

Question

I want to show a date in DD-MM-YYYY format in a datagrid. By default, SQLite stores the data in date-time format. So how can I convert date-time format to date format in flex by using SQLite?

For future readers, if you want the "usual" date format (`YYYY-MM-DD`) then you can also just use `DATE`: `SELECT DATE(date_time)` — Bilbottom, Aug 26 '23 at 07:31

score 40 · Accepted Answer · answered Jun 10 '10 at 13:26

40

You can use strftime, from Date And Time Functions.

Example:

SELECT strftime('%d-%m-%Y', 'now')

output:

10-06-2010

answered Jun 10 '10 at 13:26

Nick Dandoulakis

42,588
16
104
136

score -6 · Answer 2 · edited May 26 '16 at 19:30

-6

Look up Java until Date. It has methods to convert and is supported in SQLite. However it is mostly deprecated and replaced with Calender.

edited May 26 '16 at 19:30

Peter Mortensen

30,738
21
105
131

answered Sep 26 '13 at 22:15

David Allan Houser Jr

129
2
5

How can I convert datetime to date format in SQLite?

2 Answers2

Linked