During implementing https://jira.mongodb.org/browse/HIBERNATE-13, we found there is non-trivial complexity resolving the various time related methods, including:

• how to store time zone info?
• how to integrate with Hibernate ORM?
• how to map the types in our project?

We need to inspect the issue from both setter side (`PreparedStatement`) and getter side (`ResultSet`).

The SQL types involved includes:

• java.sql.Date
• java.sql.Time
• java.sql.Timestamp

The SQL type codes involved include:

• DATE
• TIME
• TIMESTAMP
• TIME_WITH_TIMEZONE
• TIMESTAMP_WITH_TIMEZONE

We might work on this ticket after Milestone 1 so we can use CRUD processing to experiment. Before that, we simply throw NotYetImplementedException for the JDBC methods related to them.

See also the discussion https://github.com/mongodb/mongo-hibernate/pull/24#discussion_r1921520134.

Addressing the source code notes tagged with TODO-HIBERNATE-42 is in scope of this ticket.