Re: [sqlite] Date function accepts only DD for date string

2013-11-04 Thread Simon Slavin
On 4 Nov 2013, at 7:36am, Clemens Ladisch 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

Re: [sqlite] Date function accepts only DD for date string

2013-11-03 Thread Clemens Ladisch
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). Regards, Clemens __

[sqlite] Date function accepts only DD for date string

2013-11-03 Thread Navaneeth K N
Hello, select date('2013-11-04') -> Works well select date('2013-11-4') -> Not working Is there a way to make the second form working? Currently, I handle this at the application side. If month/day is less than 10, then prefix it with 0. But I'm wondering is there a better way to do this at