ALTER TABLE "energy_assessments" ALTER COLUMN "lodgement_date" SET DATA TYPE date;--> statement-breakpoint
ALTER TABLE "energy_assessments" ALTER COLUMN "lodgement_datetime" SET DATA TYPE timestamp (6);