Postgres Pro
Downloads
Home   >   mailing lists

Re: Combine Date and Time Columns to Timestamp - Mailing list pgsql-general

From Rich Shepard
Subject Re: Combine Date and Time Columns to Timestamp
Date
Msg-id alpine.LNX.2.00.1301190636570.32614@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Combine Date and Time Columns to Timestamp  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
On Fri, 18 Jan 2013, Adrian Klaver wrote:

> test=> SELECT ('2012-10-29 '||'10:19')::timestamp;
>      timestamp
> ---------------------
> 2012-10-29 10:19:00

   Thanks, Adrian. I suspected it was simple but I could not find a reference
to the syntax.

Much appreciated,

Rich

pgsql-general by date:

Previous
From: Alexander Reichstadt
Date:
Subject: Cannot install postgres 9.2, less than 32 MB of memory
Next
From: Adrian Klaver
Date:
Subject: Re: Cannot install postgres 9.2, less than 32 MB of memory