But if we don't start worrying about the year 10,000 now, then we'll end of
having another disaster like Y2k. Oh yeah, that amounted to big fat thud.
Never mind.
:)
On Fri, Feb 3, 2012 at 8:39 AM, Black, Michael (IS)
<michael.bla...@ngc.com>wrote:
> 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: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of LacaK [la...@zoznam.sk]
> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
