The following comments are owned by whomever posted them. This site is not responsible for what they say.
Snippet: Select a Date or Current Date Without Time
Authored by: Julian Kuiters on Thursday, September 01 2005 @ 08:49 AM AEST
It's been suggested elsewhere that this method is faster in large datasets:
SELECT dateadd(d, 0, datediff(d, 0, getdate()))
[ # ]

Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 Copyright © 2018 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.