mới 1.txt
| 1 |
UPDATE DELI_REVEICE_DELIVERY_MASTER SET AUTH_STATUS = 'V' WHERE AUTH_STATUS IN ('B','C','D','V') AND CONVERT(DATE,TO_DATE, 103) <= CONVERT(DATE,'04-07-2025', 103)
|
|---|---|
| 2 |
|
| 3 |
SELECT * FROM DELI_REVEICE_DELIVERY_MASTER WHERE AUTH_STATUS IN ('B','C','D','V') AND CONVERT(DATE,TO_DATE, 103) <= CONVERT(DATE,'04-07-2025', 103)
|