2012/4/2 Jay A. Kreibich <j...@kreibi.ch> > 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. > > But may strptime() function returns datetime in format '%Y-%m-%d %H:%M:%S'?.. It's produce some overhead by expensive (string parsing) operations.
select strptime('%d.%m.%Y %H:%M:%S', '12.11.2001 18:31:01'); 2001-11-12 18:31:01 select strftime('%s', strptime('%d.%m.%Y %H:%M:%S', '12.11.2001 18:31:01')); 1005589861 -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users