-- AlterTable ALTER TABLE "Customer" ALTER COLUMN "birthDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "CustomerBranch" ALTER COLUMN "registerDate" SET DATA TYPE DATE, ALTER COLUMN "payDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "Employee" ALTER COLUMN "dateOfBirth" SET DATA TYPE DATE, ALTER COLUMN "passportIssueDate" SET DATA TYPE DATE, ALTER COLUMN "passportExpiryDate" SET DATA TYPE DATE, ALTER COLUMN "visaIssueDate" SET DATA TYPE DATE, ALTER COLUMN "visaExpiryDate" SET DATA TYPE DATE, ALTER COLUMN "visaStayUntilDate" SET DATA TYPE DATE, ALTER COLUMN "entryDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "EmployeeCheckup" ALTER COLUMN "coverageStartDate" SET DATA TYPE DATE, ALTER COLUMN "coverageExpireDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "EmployeeWork" ALTER COLUMN "workPermitIssuDate" SET DATA TYPE DATE, ALTER COLUMN "workPermitExpireDate" SET DATA TYPE DATE, ALTER COLUMN "workEndDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "Quotation" ALTER COLUMN "payBillDate" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "QuotationPaySplit" ALTER COLUMN "date" SET DATA TYPE DATE; -- AlterTable ALTER TABLE "User" ALTER COLUMN "startDate" SET DATA TYPE DATE, ALTER COLUMN "retireDate" SET DATA TYPE DATE, ALTER COLUMN "licenseIssueDate" SET DATA TYPE DATE, ALTER COLUMN "licenseExpireDate" SET DATA TYPE DATE, ALTER COLUMN "birthDate" SET DATA TYPE DATE;