MSSQL Query Executed But not updated in Table

Question

I've both MYSQL and MSSQL and I tried in MYSQL its working but MSSQL query also executed but 0 rows are affected and checked in table not yet updated.

MYSQL QUERY:

UPDATE aqi_metrics 
SET stability=:stability ,risk=:risk,days=DATE(NOW( )) 
WHERE project=:project AND days=DATE(NOW( ))

MSSQL QUERY:

UPDATE aqi_metrics 
SET stability=31 ,risk=8,days=GETDATE() 
WHERE project='JupiterQA' AND days=GETDATE()

what is the error in MSSQL query?

What is the datatype of `days` column also what happens when you run `select * from aqi_metrics WHERE project='JupiterQA' AND days=GETDATE()` — Pரதீப், Mar 03 '15 at 12:07
`DATE(NOW( ))` is not the same as `GETDATE()`. Try`CAST(GETDATE() AS DATE)` — Nick.Mc, Mar 03 '15 at 12:40

score 0 · Answer 1 · answered Mar 03 '15 at 12:10

0

GETDATE() returns a date time - so it will have the time in there too. You need to convert both to date data type to just compare the date. For example.

UPDATE aqi_metrics 
SET stability=31 ,risk=8,days=GETDATE() 
WHERE project='JupiterQA' AND CONVERT(date, days) = CONVERT(date, getdate())

answered Mar 03 '15 at 12:10

Donal

31,121
10
63
72

agree with this but for performance change to days >= CONVERT(date, getdate()) – user16181 Sep 02 '22 at 09:07

MSSQL Query Executed But not updated in Table

1 Answers1