Formatting time for INSERT INTO

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Formatting time for INSERT INTO
Date: 2012-04-25 22:01:49
Message-ID: alpine.LNX.2.00.1204251459010.18855@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2012-04-25 22:35:57 Re: Formatting time for INSERT INTO
Previous Message Guillaume Lelarge 2012-04-25 21:05:53 Re: how robust are custom dumps?