Re: Fw: questions in query on 7.1 and 7.2

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Alex Cheung Tin Ka <tkcheung(at)vtc(dot)edu(dot)hk>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fw: questions in query on 7.1 and 7.2
Date: 2002-07-29 14:08:14
Message-ID: 20020729070727.E92453-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Elielson Fontanezi 2002-07-29 14:08:25 back space key and arrows keys
Previous Message Oliver Kohll 2002-07-29 13:58:44 Re: Is there any such thing as PostgreSQL security on a hosted website?