type conversion date <-> timestamp - Mailing list pgsql-general

From Ulrich Wisser
Subject type conversion date <-> timestamp
Date
Msg-id 40A88A9E.6070603@relevanttraffic.se
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Nick Barr
Date:
Subject: Re: table column information
Next
From: Milos Prudek
Date:
Subject: serial autoincrement and related table