[MonetDB-users] converting strings to dates?

m h sesquile at gmail.com
Tue Dec 4 00:29:35 CET 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




More information about the users-list mailing list