HP 3000 Manuals HP 3000 Manuals
Where Date/Time Functions Can Be Used
Use date/time functions, as you would an expression, in the DML
operations listed below:
Table 11-1. Where to Use Date/Time Functions
---------------------------------------------------------------------------------------------
| | |
| DML Operation | Clause |
| | |
---------------------------------------------------------------------------------------------
| | |
| [BULK]INSERT 1 | VALUES |
| | |
| | WHERE |
| | |
---------------------------------------------------------------------------------------------
| | |
| UPDATE or | SET |
| | |
| UPDATE WHERE CURRENT | WHERE |
| | |
---------------------------------------------------------------------------------------------
| | |
| DELETE or | WHERE |
| | |
| DELETE WHERE CURRENT | |
| | |
---------------------------------------------------------------------------------------------
| | |
| [BULK]SELECT | Select list 2 |
| | |
| | WHERE |
| | |
---------------------------------------------------------------------------------------------
| | |
| DECLARE | Select list 2 |
| | |
| | WHERE |
| | |
---------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
| |
| 1 In the case of a [BULK] INSERT, output functions, TO_CHAR and TO_INTEGER, and the |
| ADD_MONTHS function, are limited to use in the select list and the WHERE clause of a |
| Type 2 INSERT. |
| |
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
| |
| 2 Input functions, TO_DATE, TO_TIME, TO_DATETIME, and TO_INTERVAL, are generally not |
| appropriate in a select list. |
| |
------------------------------------------------------------------------------------------