Re: [GENERAL] scheduling table design
Patrick Welche <prlw1@newn.cam.ac.uk>
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: kaiq@realtyideas.com
Cc: pgsql-general@postgresql.org
Date: 2000-02-25T15:54:24Z
Lists: pgsql-general
On Fri, Feb 25, 2000 at 09:56:59AM -0600, kaiq@realtyideas.com wrote: > > do not use date, use datetime. why? it's sql92 standard (another > good reason: M$sql only has datetime :-). A lot of useful functions > only apply to datetime, not date. On a side note: if I have a date d and a time t column, how can I combine them into a single datetime dt column? Simply insert into foo (dt) select (d+t)::datetime ?