Postgres Pro
Downloads
Home   >   mailing lists

Re: Formatting time for INSERT INTO - Mailing list pgsql-general

From Ben Chobot
Subject Re: Formatting time for INSERT INTO
Date
Msg-id 8434DAE6-DB47-4062-BA29-F82967976025@silentmedia.com
Whole thread Raw
In response to Formatting time for INSERT INTO  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Formatting time for INSERT INTO
List pgsql-general
Tree view 
On Apr 25, 2012, at 4:01 PM, Rich Shepard wrote:

>  The table has a column 'coll_time' of type time without time zone. New
> rows for the table are in a .sql file and the time values throw an error at
> the colon between hours:minutes. Do time values need to be quoted?

Yes, (date)time values need to be quoted as if they were strings.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Formatting time for INSERT INTO
Next
From: Rich Shepard
Date:
Subject: Re: Formatting time for INSERT INTO