using datepart function get different output

Posted on May 6, 2008. Filed under: Sql Server |

selectdatepart(year,getdate())

selectdatepart(month,getdate())

select datepart(day,getdate())

select datepart(hour,getdate())

select datepart(minute,getdate())

select datepart(second,getdate())

select datepart(millisecond,getdate())

select datepart(weekday,getdate())

select datepart(dayofyear,getdate())

select datepart(quarter,getdate())

Make a Comment: ( None so far )