On Sun, Feb 18, 2007 at 12:29:17 +0100,
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
>
> The date-of-birth field in our table holding patients is of
> type "timestamp with time zone". One of our patient search
> queries uses the date-of-birth field to find matches. Since
> users enter day, month, and year but not hour, minute, and
> second of the DOB we run the query with
That seems like an odd choice. Is there some reason they didn't use a type
of date? Maybe you could get them to change it?