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

On 01/18/2013 04:26 PM, Rich Shepard wrote:
> On Fri, 18 Jan 2013, Adrian Klaver wrote:
>
>> How are they stored, as date and time type, strings, other?
>
> Adrian,
>
>    ISO date and time.
>
>> A sample of the data would help also.
>
>    Example:  2012-10-29  |  10:19   | 2012-10-30  | 09:40

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

>
> Rich
>
>
>


--
Adrian Klaver
adrian.klaver@gmail.com