How to convert date formats in SQLite

Date types are handled like a string in SQLite and below is an example of how to change the date format from MM/dd/yyyy to yyyy-MM-dd. With a little modification it can be used for other formats too.

select substr(column, 7, 4)||”-“||substr(column, 1,2)||”-“||substr(column, 4,2) from table

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.