Re: Joining dates/times (was Re: Splitting Timestamps) - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Joining dates/times (was Re: Splitting Timestamps)
Date
Msg-id 20060730080030.GA32129@KanotixBox
Whole thread Raw
In response to Joining dates/times (was Re: Splitting Timestamps)  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Joining dates/times (was Re: Splitting Timestamps)
List pgsql-general
Ron Johnson <ron.l.johnson@cox.net> schrieb:
> >> I know I can do a select to_date(now(),'yyyy-mm-dd') and it will return the
> >> date.  However, how do I get the time?  Also, is this the proper way to get
> >> the date portion of a timestamp?
> >
> > select now()::timetz;
> > select now()::time;
> > select now()::date;
>
> What's the inverse?  Say I have a DATE and a TIME, and want to
> create a TIMESTAMP with them?

You can CAST it:

test=# select '2006/07/29 10:00:00'::timestamp;
      timestamp
---------------------
 2006-07-29 10:00:00
(1 row)

or:

test=# select ('2006/07/29'::date || ' ' || '10:00:00'::time)::timestamp;
      timestamp
---------------------
 2006-07-29 10:00:00
(1 row)


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Joining dates/times (was Re: Splitting Timestamps)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Joining dates/times (was Re: Splitting Timestamps)