KnowledgeBase
a KnowledgeBase blog for my random thoughts and observations...
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment