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>
