Many DBs especially SQL based DBs support separate date and time types.
We should do a pass on all our connectors and ensure that they support DateOnly and TimeOnly on those DBs where this is valuable.
We should also make sure that all our databases support dates with and without timezones in a consistent way.