From: Scott Marlowe <smarlowe@g2switchworks.com>
To: RPK <rpk.general@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Retrieve month from date
Date: Fri, 20 Apr 2007 12:46:28 -0500
Message-ID: <1177091187.24411.25.camel@state.g2switchworks.com> (raw)
In-Reply-To: <10106861.post@talk.nabble.com>
References: <11604f180704200519h5d858f6ey1efbbccd52ccd0c9@mail.gmail.com>
<4628CE32.A3DD.0030.0@indicator.be>
<10106861.post@talk.nabble.com>
On Fri, 2007-04-20 at 12:30, RPK wrote:
> What this query will return:
>
> Select Extract(Month from 4/20/2007) from dual;
>
> I suspect "dual" is not for PGSQL but Oracle. But I need to run the above
> query. What is the replacement of "dual" in PGSQL.
>
Well, you're going to have to create a special one row table with
contraints and triggers to always keep it at one row and now allow
anyone to insert into it and...
just kidding. All you need is:
select extract(month from '4/20/2007'::date);
i.e. no need for the extraneous from dual there.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, rpk.general@gmail.com
Subject: Re: Retrieve month from date
In-Reply-To: <1177091187.24411.25.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox