I am currently working on a project that utilizes SQLite. I need to covert a stored date format from MM/DD/YYYY to YYYY/MM/DD. However, I don't know how to convert in SQLite.
Asked
Active
Viewed 110 times
0
-
Using substr(,7,4) + '/' +substr, 1,2) + '/' +substr(,4,2)? – Jeroen Heier Jul 16 '17 at 04:59
1 Answers
-1
Please take a look here:
https://sqlite.org/lang_datefunc.html
What you need is strftime function to specify the format.
Dan R.
- 638
- 5
- 13
-
The input is not one of `strftime()`'s [supported date formats](http://www.sqlite.org/datatype3.html#datetime). – CL. Jul 16 '17 at 05:49