Re: problem with a column of type timestamp

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Sascha Bohnenkamp <bohnenkamp(at)mevisbreastcare(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with a column of type timestamp
Date: 2007-10-16 16:30:08
Message-ID: 2F8EE15B-ADA8-4E65-A986-65D03D2425B0@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 16, 2007, at 1:55 , Sascha Bohnenkamp wrote:

> 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?

The issue isn't the time zone: I believe it's that one is a
*timestamp* while the other is a *time*;

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stanislav Raskin 2007-10-16 16:38:37 Updating a production database schema from dev server
Previous Message brian 2007-10-16 16:27:50 Re: problem with a column of type timestamp