Stored DATETIME defaults to revert to DATE on core/all date fields e.g. DoB #264
Description
Fields such as pers_dob and all other date fields are currently defined as DATETIME, stored as binary datetime value.
This ticket to consider the value and/or knock-on impact for LAs of converting columns to pure DATE, where SSMS will render as YYYY-MM-DD and remove time entirely, to simplify down/upstream comparisons. Original decision was based on not knowing CMS landscape nor LA needs for fuller time data + defining a single consistent approach across all date fields for simplicity when interacting.
Current: 2024-12-10 00:00:00.000 is the SSMS default rendering of dt, ISO like, but not true ISO.
i.e. no T 2024-12-10T00:00:00.000 (style 126).
desired change to : 2024-12-10 (with onward DfE representations needed as 10/12/2024(stat returns), 2024-12-10 (EA AP JSON)