KnowledgeBase
a KnowledgeBase blog for my random thoughts and observations...
Thursday, October 9, 2008
Date conversion
SELECT
@TodayAtNoon
=
CAST
(
CAST
(
Month
(
getDate
())
as
nvarchar
(
2
))
+
'/'
+
CAST
(
Day
(
getDate
())
as
nvarchar
(
2
))
+
'/'
+
CAST
(
Year
(
getDate
())
as
nvarchar
(
4
))
+
' 12:00:00.000'
as
datetime
)
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment