It would be nice to be able to add a LocalDate and a LocalTime within a query. Possible implementation in TSQL are: https://dba.stackexchange.com/questions/51440/how-to-combine-date-and-time-to-datetime2-in-sql-server