Postgres Pro
Downloads
Home   >   mailing lists

Retrieve month from date - Mailing list pgsql-sql

From Rohit Khare
Subject Retrieve month from date
Date
Msg-id 11604f180704200519h5d858f6ey1efbbccd52ccd0c9@mail.gmail.com
Whole thread Raw
Responses Re: Retrieve month from date  ("Bart Degryse" <Bart.Degryse@indicator.be>)
Re: Retrieve month from date  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Retrieve month from date  (RPK <rpk.general@gmail.com>)
List pgsql-sql
Tree view 
I am using PGSQL 8.2.3 on Windows XP.<br /><br />I have a table called "StudentFeesPayment" with columns "ReceiptNo"
and"ReceiptMonthYear".<br />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. <br /><br />I tried:<br /><br />Select
max(ReceiptNo)from StudentFeesPayment where Extract(Month('ReceiptMonthYear'))=4;<br /><br />But it is not working. How
todo it?<br /><br />

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: many 'OR' in WHERE-condition
Next
From: "A. Kretschmer"
Date:
Subject: Re: many 'OR' in WHERE-condition