select dateadd(dd, datediff(dd, 0, getdate()), 0)

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT DATEADD(dd,1, CONVERT(varchar(10),GetDate(),101))
SELECT DATEADD(dd,5, CONVERT(varchar(10),GetDate(),101))

edited sep 13 17

created mar 29 11

anonymous

Enter Parameters

Options: Text-only results Include execution plan

Switch to main site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached