-- To convert a datetime to a date, you can use the CONVERT(), TRY_CONVERT(), or CAST() function. -- Note that the GETDATE() function returns the current database server’s datetime.
CurrentValue contains a date in MM/DD/YYYY format (actually a string value). I want to compare it with the current date minus 180 days. With @kmsigma we have tried several queries but with the same ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback