UPDATE LEDGER SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE WAREHOUSE SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE VAT_TRANSACTION SET VAT_TRAN_DATE = cast(VAT_TRAN_DATE as date) WHERE VAT_TRAN_DATE <> cast(VAT_TRAN_DATE as date)
GO
UPDATE VAT_TRANSACTION SET TRAN_DATE_ORIG = cast(TRAN_DATE_ORIG as date) WHERE TRAN_DATE_ORIG <> cast(TRAN_DATE_ORIG as date)
GO
UPDATE VOUCHER SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE SALE SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE SO SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE PURCHASE SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE POS_SALE SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO
UPDATE POS_PURCHASE SET TRAN_DATE = cast(tran_date as date) WHERE TRAN_DATE <> cast(tran_date as date)
GO