Thread: type conversion date <-> timestamp

type conversion date <-> timestamp

From
Ulrich Wisser
Date:
Hi,

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