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.1301181624450.16366@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Combine Date and Time Columns to Timestamp  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Combine Date and Time Columns to Timestamp  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Combine Date and Time Columns to Timestamp  (Steven Schlansker <steven@likeness.com>)
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:

> 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

Rich

pgsql-general by date:

Previous
From: sumesh
Date:
Subject: multiple stored procedures usage and updation
Next
From: Adrian Klaver
Date:
Subject: Re: Combine Date and Time Columns to Timestamp