From: Michael Fuhr <mike@fuhr.org>
To: RPK <rpk.general@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Retrieve month from date in SQl query
Date: Mon, 23 Apr 2007 01:41:31 -0600
Message-ID: <20070423074131.GA75312@winnie.fuhr.org> (raw)
In-Reply-To: <10063035.post@talk.nabble.com>
References: <10063035.post@talk.nabble.com>
On Wed, Apr 18, 2007 at 10:36:14AM -0700, RPK wrote:
> I have a table called "StudentFeesPayment" with columns "ReceiptNo" and
> "ReceiptMonthYear".
> The column, "ReceiptMonthYear" stores date in the format "yyyy-mm-dd". I
> have to find the max(ReceiptNo) where Month of (ReceiptMonthYear)=4. Or
> whatever month I give.
>
> I tried:
>
> Select max(ReceiptNo) from StudentFeesPayment where
> Extract(Month('ReceiptMonthYear'))=4;
>
> But it is not working. How to do it?
Please explain how it's not working -- how does the result differ
from your expectation? I'd guess you're getting a syntax error;
see the documentation for the correct way to use extract():
http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
--
Michael Fuhr
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: mike@fuhr.org, rpk.general@gmail.com
Subject: Re: Retrieve month from date in SQl query
In-Reply-To: <20070423074131.GA75312@winnie.fuhr.org>
* 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