Monday, October 17, 2011

How to get only DATE portion out of DATETIME column in MSSQL ?

cast(gerdate() as date)

,
DATEADD(dd, 0, DATEDIFF(dd, 0, EffectiveAsOfDate)) as EffectiveAsOfDate2

, CONVERT(varchar(8), EffectiveAsOfDate, 112) as EffectiveAsOfDate3
, cast(cast((EffectiveAsOfDate - 0.500000038580247) as int) as datetime) as EffectiveAsOfDate4
 , CONVERT(CHAR(10),GETDATE(),103) as EffectiveAsOfDate5

No comments:

Post a Comment