Re: problem with a column of type timestamp - Mailing list 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