How to get Year and Month of a DATE using Toad : How can I get the year and month of a date in the where clause using TOAD, I used to be working with SQL server and it was as simple as YEAR(FIELDNAME) and MONTH(FIELDNAME). Your help is really appreciated. 