On Mon, Apr 02, 2012 at 08:38:37PM +0400, Alexey Pechnikov scratched on the wall: > Why we can't control this? As example, in Russia the date format is > DD.MM.YYYY and is needed the patch > http://sqlite.mobigroup.ru/fdiff?v1=288ad2e1e017565c&v2=720cb1015e95af7a > > I think the new pragmas DATEFORMAT and TIMEFORMAT will be helpful for > internationalization. These may be used for parsing and formatting dates.
It would make more sense to just implement a strptime() SQL function to compliment the existing strftime() function. That would allow SQLite to understand and convert any incoming date-time format without depending on specific build parameters. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
