On 4 Nov 2013, at 7:36am, Clemens Ladisch <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
