From: | <kaiq(at)realtyideas(dot)com> |
---|---|
To: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] scheduling table design |
Date: | 2000-02-25 16:58:38 |
Message-ID: | Pine.LNX.4.10.10002251054280.8767-100000@picasso.realtyideas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 25 Feb 2000, Patrick Welche wrote:
> 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 ?
>
converting it? not too late :-)
seriously: sounds right. I remember somebody asked that before. and a
smart guy find out the formula thro experiment, very impressive -- the
plus (+) is important. not tested myself tho. check the archive please.
BTW, how do you know it's plus (+)? are you genius?
From | Date | Subject | |
---|---|---|---|
Next Message | davidb | 2000-02-25 17:17:09 | Re: [GENERAL] scheduling table design |
Previous Message | Ed Loehr | 2000-02-25 16:54:14 | Re: [GENERAL] scheduling table design |