Home > mailing lists

Re: Fw: questions in query on 7.1 and 7.2 - Mailing list pgsql-general

From	Stephan Szabo
Subject	Re: Fw: questions in query on 7.1 and 7.2
Date	July 29, 2002 13:08:11
Msg-id	20020729070727.E92453-100000@megazone23.bigpanda.com Whole thread Raw
In response to	Fw: questions in query on 7.1 and 7.2 ("Alex Cheung Tin Ka" <tkcheung@vtc.edu.hk>)
List	pgsql-general

Tree view

On Mon, 29 Jul 2002, Alex Cheung Tin Ka wrote:

> ... extract(month from timestamp '"op_str_time"') = 4...

That form is explicitly for timestamp literals AFAIK. op_str_time isn't
one. :)

Try CAST(op_str_time as timestamp).

pgsql-general by date:

From: nconway@klamath.dyndns.org (Neil Conway)
Date: 29 July 2002, 12:53:42
Subject: Re: pg_controldata question

From: Elielson Fontanezi
Date: 29 July 2002, 13:08:15
Subject: back space key and arrows keys

Re: Fw: questions in query on 7.1 and 7.2 - Mailing list pgsql-general

Previous

Next