Re: [GENERAL] scheduling table design

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: kaiq(at)realtyideas(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] scheduling table design
Date: 2000-02-25 15:54:24
Message-ID: 20000225155424.A5764@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 25, 2000 at 09:56:59AM -0600, kaiq(at)realtyideas(dot)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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message kaiq 2000-02-25 15:56:59 RE: [GENERAL] scheduling table design
Previous Message Barnes 2000-02-25 14:28:37 RE: [GENERAL] scheduling table design