Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from MyTable where to_char(MyDateColumn, 'dd.MM.yyyy') like '%2009'
- select * from MyTable where year(MyDateColumn) = 2009
- select * from MyTable where datepart(yy, MyDateColumn) = 2009
- select * from MyTable where DATEPART(year, MyDateColumn) = 2009
Add Comment
Please, Sign In to add comment