pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRetrieve month from date in SQl query
2+ messages / 2 participants
[nested] [flat]
* Retrieve month from date in SQl query
@ 2007-04-18 17:36 RPK <rpk.general@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: RPK @ 2007-04-18 17:36 UTC (permalink / raw)
To: pgsql-sql
I am using PGSQL 8.2.3 on Windows XP.
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?
--
View this message in context: http://www.nabble.com/Retrieve-month-from-date-in-SQl-query-tf3602302.html#a10063035
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Retrieve month from date in SQl query
@ 2007-04-23 07:41 Michael Fuhr <mike@fuhr.org>
parent: RPK <rpk.general@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2007-04-23 07:41 UTC (permalink / raw)
To: RPK <rpk.general@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-23 07:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-18 17:36 Retrieve month from date in SQl query RPK <rpk.general@gmail.com>
2007-04-23 07:41 ` Michael Fuhr <mike@fuhr.org>
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