Oops - forgot
select * from some_table where strftime( '%Y', date_col ) = '2006'
On Mar 29, 2006, at 3:04 PM, Jay Wooten wrote:
Is the only way to select the year portion of a date in REALSQL
like this
select * from some_table where substr( date_col, 1, 4 ) = '2006'
We tried
select * from some_table where year(date_col) = '2006' / or 2006
but that doesn't seem to work..
and yes I reviewed the link at the sqlite site
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
But it was mentioned a couple of years ago on the nug that SQLite
had date functions
http://support.realsoftware.com/listarchives/realbasic-nug/2003-11/
msg00094.html
- Jay
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
