[MonetDB-users] converting strings to dates?

3 Dec 2007

      In Oracle I can do the following:

select *
from table
where timestampcol BETWEEN to_date('01/01/07', 'MM/DD/RR') AND
to_date('12/31'/07'), 'MM/DD/RR')

It's not clear that this is possible in monetdb.

There's the EXTRACT function which pulls a numeric value (month, day
or year) from a string representing a timestamp, but I can't see how
to get a timestamp/date object out?

-matt

[MonetDB-users] converting strings to dates?

m h