type conversion date <-> timestamp

От:

Ulrich Wisser <ulrich.wisser@relevanttraffic.se>

Дата:

17 мая 2004 г. в 06:50:10

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