today I started to wonder about type conversion. I want to get all rows of a table dated between two given dates. Until now I use
select * from mytable where to_date('20040115', 'YYYYMMDD') <= timestamp
and timestamp <= to_date('20040215', YYYYMMDD')Does that query include the 15th January as well as the 15th February?
TIA
Ulrich
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
