Re: [GENERAL] scheduling table design

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?