I had to deal with a similar conversion.
I think the answer to why date() does not take other formats is simple: SQLite
is minimalistic. This string processing can be done outside SQLite library.
Minimalism of SQLite is one of the criteria for what gets implemented. It has
few mathematical operations, few string manipulations, subset of SQL, etc.
Sqlite developers are very good at choosing which few to implement to give
maximum of versatility. Every time I notice such decision I get more impressed.
I hope you will experience such joy as well.
________________________________________
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Jose Isaias Cabrera [jic...@outlook.com]
Sent: Monday, October 07, 2019 9:17 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Date time input
Greetings.
I have to ask this question: Why is it that the date function does not take a
'4/5/2019' and returns '2019-04-05'? This may have been asked before, and the
answer may be some where in the internet, but, I could not find it. The other
thing is that it would be nice to have date take something like this,
date('2/15/2019','m/d/yyyy')
and return
2019-02-15
so I don't have to deal with the changes. :-) Just wishing out-loud... Thanks.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailinglists.sqlite.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsqlite-users&data=02%7C01%7Croman.fleysher%40einstein.yu.edu%7Cfa23548f95114997012508d74b28b25c%7C04c70eb48f2648079934e02e89266ad0%7C1%7C1%7C637060510468196612&sdata=kxiXOugWi%2FGEmGs%2FKi7FTyK4xpipJeCmK0EBv9qkbFc%3D&reserved=0
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
