CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)
Never been to CodeSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
Get a date without time in SQL (See related posts)
You need to create an account or log in to post comments to this site.
Related Posts
» Selecting different parts of... in time date sql timestamp mssql language query transact structured datetime parts part stamp only sub
» How to setup NTP on BSD in ntpdate ntpd ntp.conf time date
» date time in ruby in ruby time date
» Local time/date in date
» Measure the daily number of ... in email date perl shell bash mime day mailbox
» Calculate Thanksgiving Date in php date calculate thanksgiving holiday timestamp strtotime
Snippets (source code soon to be available) developed by Peter Cooper and powered by Ruby On Rails