Re: [GENERAL] scheduling table design - Mailing list pgsql-general

From Patrick Welche
Subject Re: [GENERAL] scheduling table design
Date
Msg-id 20000225155424.A5764@quartz.newn.cam.ac.uk
Whole thread Raw
In response to RE: [GENERAL] scheduling table design  (<kaiq@realtyideas.com>)
Responses Re: [GENERAL] scheduling table design  (<kaiq@realtyideas.com>)
List 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 ?

pgsql-general by date:

Previous
From:
Date:
Subject: RE: [GENERAL] scheduling table design
Next
From:
Date:
Subject: Re: [GENERAL] scheduling table design