[Gambas-user] sqlite3/date

[Benoit Minisini]

On Thursday 19 January 2006 22:44, Rob Kudla wrote:
> 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
>

Another proof that SQL is well standardized :-)

-- 
Benoit Minisini