Operations can be performed on date and time data in a table, and retrieval results based on a specific period of time can be extracted.

Scalar functions are used to operate date or time data. Date operations are used for date data, and time operations are used for time data.

The following figure shows, as an example of performing a time operation on data, the procedure for extracting from the sales order table the form numbers, product codes, and quantities ordered for all orders received before noon (12:00:00).

Figure 2-34 Example of time data operation