On Mar 12, 2009, at 12:08 AM, jonwood wrote:
> Doug Currie-2 wrote:
>>
>> Note the '/'s
>>
>
> What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1')
> return?
> Does DATE() simply have no effect whatsoever?
Sorry to be cryptic.
sqlite> select date('2009/12/03');
sqlite> select date('2009-12-03');
2009-12-03
sqlite>
The '/'s format is not supported by DATE.
See: http://www.sqlite.org/lang_datefunc.html
e
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
