selecting day and month in date

[Anon]

The example in below is in MY_SQL.
I want do the same in POSTGRES,
Help-me please!

SELECT * FROM user WHERE MONTH(birthdate)=11 AND DAYOFMONTH(birthdate)=18;

[Anon]

http://www.postgresql.org/idocs/index.php?functions-datetime.html

look for function extract

[Anon]

Read the manual.

Note that the MySQL syntax is totally non-standard and the Postgres syntax is SQL99 standard, and will work on all standard databases.

SELECT * FROM users WHERE EXTRACT(MONTH FROM birthdate)=11 AND EXTRACT(DAY FROM birthdate)=18;

Postgres 7.2+

Chris