Non-standard ISO format....already doable like this:
sqlite> select substr(strftime("%Y",'now'),3,2);
12
This will work until the year 10,000 :-)
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: [email protected] [[email protected]] on
behalf of LacaK [[email protected]]
Sent: Friday, February 03, 2012 3:37 AM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] support of %y in strftime()
Hi *,
there is date-time formating function strftime(), which supports some
(not all) string formating parameters (like %d, %m, %Y)
There is %Y for 4-digit year.
Is possible add also %y for 2-digit year ? (like in strftime() in
standard C library)
If it is not a big problem (I hope, that isn't), I would be very happy
if it will be implemented.
(can I post somewhere bug report, feature request)
TIA
-Laco.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
