Thanks a lot for your answers, I had a look to the wiki but missed the entry.
I was also wondering, the date and time functions (I'm thinking of date(), strftime(), ...) would make the sql queries not SQL92 compliant, woudn't them?
Thanks,
Guille
D. Richard Hipp wrote:
SELECT strftime("%m",time) FROM test;
Kurt Welgehausen wrote: > Take a look at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
