On 4 Nov 2013, at 7:36am, Clemens Ladisch <clem...@ladisch.de> wrote:
> Navaneeth K N wrote: >> select date('2013-11-04') -> Works well >> select date('2013-11-4') -> Not working >> >> Is there a way to make the second form working? > > Only by inserting a zero into the string (which isn't easy > with the built-in SQL functions). Right. I recommend that you turn date strings into dates (integers or reals) in your programming language if at all possible. Most of them have libraries that do this stuff. SQLite may have a function in that appears to do it but it's not really designed for that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users