problem with a column of type timestamp

From: Sascha Bohnenkamp <bohnenkamp(at)mevisbreastcare(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with a column of type timestamp
Date: 2007-10-16 06:55:11
Message-ID: 5nj5ifFim67sU1@mid.individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table of type timestamp.
I get the following error when I try to insert som edata to it:

PGRES_FATAL_ERROR
column "birthtime" is of type timestamp without time zone but expression
is of type time without time zone You will need to rewrite or cast the
expression.

how can I set the timezone?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-10-16 07:10:00 Create artificial key without temp sequence
Previous Message Greg Smith 2007-10-16 04:39:20 Re: Problems inserting data into a table with a sequence