Querying date data type according to month, day or year

[gust1480]

Can somebody please tell me how i can do a query on a date datatye according to month or day or year or combination of month and day or month n year and so on. Thanks!

 

[johnherman]

check out the datepart, or year, month, and day built-in functions.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[iBe]

for the date '01/01/1900'...

SELECT *
FROM _TABLE_
WHERE MONTH(_DATEFIELD_) = '01'
       And DAY(_DATEFIELD_) = '01'
       And YEAR(_DATEFIELD_) = '1900'

Might work.