Free since 2005 · No login required
AT

Academic Tutorials

Learn at your own pace

site-mobile-top-banner · 320x50

How to get rid of the time part from the date returned by GETDATE function?

We have to use the CONVERT function to strip the time off the date. SELECT CONVERT(char,GETDATE(),101)