Hi,

Use following syntax:

To get day     : select datepart(day,getdate())

To get month :  select datepart(month,getdate())

To get year    :  select datepart(year,getdate())

Thanks

Bingi