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
Realized this would be a better form:
test=> SELECT ('2012-10-29'|| ' ' || '10:19')::timestamp;
>
> Rich
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com