Update Date between two Dates in SQL Server

Question

How to update date between two date  Eg 01july2017 and 10072017  Iwant to change all the date between these date to 20072017

zameer · Accepted Answer

Hi SUJAYSAs per your query i have create the sampleIf you have any doubt please revert me backBelow is the given sampleSQLDECLARE  DATES TABLEDates DATETIMEINSERT INTO DATES VALUES390701201739INSERT INTO DATES VALUES390702201739INSERT INTO DATES VALUES390703201739INSERT INTO DATES VALUES390704201739INSERT INTO DATES VALUES390705201739INSERT INTO DATES VALUES390717201739INSERT INTO DATES VALUES390714201739INSERT INTO DATES VALUES390720201739INSERT INTO DATES VALUES390725201739UPDATE  DATES SET Dates 390720201739 WHERE Dates BETWEEN 390701201739 AND 390710201739Output   Dates7202017 0007202017 0007202017 0007202017 0007202017 0007172017 0007142017 0007202017 0007252017 000

SUJAYS · Answer

I got the answerUpdate sample Set EntryDate 3930Jul201739 where EntryDate between 3901jul201739 and 3910Jul201739

Update Date between two Dates in SQL Server

Company

Explore

Follow us

Contact Us