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.

Figure 2-34 shows an example of a time data operation. Here, the form numbers, the product codes, and the ordered quantities for orders received before noon (12:00:00) are extracted from the sales orders table.

Figure 2-34 Example of time data operation