Date and time data may be supplied using DateObject, TimeObject or SQLDateTime. Create a table with DATE, TIME, and DATETIME column types:

Generate some data for insertion:

Insert the generated data:

Selected date and time data will return with head SQLDateTime:

Express the selected data in its original form:

Clear the table:

A DATE column will ignore minute, hour, and second elements in supplied date constructs. A TIME column will ignore year, month, and day elements in supplied date constructs.

For column types that record both date and time elements, the time will be taken to be 00:00:00 if not supplied. The date will be taken to be today if not supplied:

Adjust batch size to trade off memory use and speed when issuing queries with long parameter lists:

Generate random data for insertion:

Compute memory in use, including both kernel and Java layers:

Run query with small batch size, resulting in relatively light Java-side memory use:

Reset:

Rerun with larger batch size, necessitating fewer server trips:

Java memory use is higher in this case:

Switch parameter batching from Java layer to Wolfram Language layer to trade speed for memory:

Generate random data for insertion:

Compute memory in use, including both kernel and Java layers:

Run query with Java-side batching:

Reset:

Run query with Wolfram Language-side batching:

Total memory use is lower in this case: