Re: Combine Date and Time Columns to Timestamp
От
Adrian Klaver
Тема
Re: Combine Date and Time Columns to Timestamp
Дата
Msg-id
50F9E9ED.10906@gmail.com
Ответ на
Re: Combine Date and Time Columns to Timestamp (Rich Shepard)
Список
Дерево обсуждения
Combine Date and Time Columns to Timestamp Rich Shepard <rshepard@appl-ecosys.com>
Re: Combine Date and Time Columns to Timestamp Adrian Klaver <adrian.klaver@gmail.com>
Re: Combine Date and Time Columns to Timestamp Rich Shepard <rshepard@appl-ecosys.com>
Re: Combine Date and Time Columns to Timestamp Adrian Klaver <adrian.klaver@gmail.com>
Re: Combine Date and Time Columns to Timestamp Rich Shepard <rshepard@appl-ecosys.com>
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>
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
В списке pgsql-general по дате отправления
