On Sun, Feb 18, 2007 at 12:29:17 +0100, Karsten Hilbert <[EMAIL PROTECTED]> 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? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
