Dates in SQL 6.5

[skhanal]

You can use datepart function like

select datepart(month,getdate())