{
DECLARE @DOUT DATETIME
SET @DOUT = CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 101))
PRINT CONVERT(DATETIME, @DOUT)
}
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Blogroll
About Me
- David Seruyange
- I am a software developer living in the middle west. My day job is typically with Microsoft development tools, at night I'm a tinkerer, language connoisseur, and wanderer.
Posts
1 comment:
Hi Please check this out. It suggested a similar way to strip the time part from date time.
http://cherupally.blogspot.com/2009/09/easy-way-to-strip-time-part-in-sql-date.html
Thanks,
Kiran
http://cherupally.blogspot.com
Post a Comment