How can i convert datetime to date format in sqlite

Question

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

Answer 1

You can use strftime, from Date And Time Functions.

Example:

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

output:

10-06-2010

Answer 2

SQLite date and time functions