Date Extraction

[Aditi agarwal]

hey i have a table in which i have a field with date & time but its data type is date

now i want to comapre my this field on basis of month & year entered by me

Now i want to know how can i extract month & year only from my this field in database

Please help me

thank you

[Swastik Dey]

Does this help?

select date_trunc(month,datefieldname) from tablename
select date_trunc(year,datefieldname) from tablename

http://developer.postgresql.org/pgdocs/postgres/functions-datetime.html

[Rob Spoor]

Which of course won't work in several other servers like MS SQL Server. That one has functions YEAR, MONTH, DAY and DATEPART. So without knowing the database server in question we cannot answer this question (unless we provide the answer for each and every database server available).