Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Beginner
Apr 5, 2002

Pull a Date From SQL Server DateTime


SQL Server stores datetime data in 8 bytes. The first four bytes represent the date and the second four represent the time. To axe off the time part of the datetime, convert the datetime to a float, truncate the decimals, then convert back to a datetime. Converting directly to an integer will round up to the next day if the date is after 12PM.
 
select cast
(round(cast(getdate() as float),0,1) as datetime)

select count(*) from Sales where cast
(round(cast(SaleCreateDate as
float),0,1) as datetime) between '12/24/01' and '12/25/01'
Chris McDowell
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date