Tuesday, 6 May 2008

using datepart function get different output

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())
Share:

0 Comments:

Post a Comment