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

On Jan 18, 2013, at 4:26 PM, Rich Shepard <rshepard@appl-ecosys.com> 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


steven=# create temporary table date_test (d varchar, t varchar);
CREATE TABLE
steven=# insert into date_test values('2010-08-23', '8:04:33');
INSERT 0 1
steven=# select d::date + t::interval from date_test;
      ?column?
---------------------
 2010-08-23 08:04:33
(1 row)