[Gambas-user] sqlite3/date

Rob Kudla sourceforge-raindog2 at ...94...
Thu Jan 19 22:44:10 CET 2006


On Thu January 19 2006 15:21, Rohnny Stormo wrote:
> How to select fields from a chosen month on sqlite3.
> Tried with WHERE month(dato)=1 but it looks like that
> function(month) are not aviable

Here's the SQLite documentation for their time/date functions....

http://www.sqlite.org/cvstrac/wiki/wiki?p=DateAndTimeFunctions

It looks like there is no month(), day(), year(), etc.  But you 
might be able to do "where strftime('%m', mydate) = 0" to get 
January dates.... give it a try.

Rob




More information about the User mailing list