Convert DateTime to Date in SQL Server

Posted by admin on Nov 26, 2009 in Uncategorized |
Subscribe
SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DateField)))

Leave a Reply

XHTML: You can use these tags:' <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Copyright © 2008-2010 Brinsmead Data Services All rights reserved.