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 the SQLite side itself?

--
Cheers,
Navaneeth

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to