Incompatibility
The functions below have been added to the functions for which VCI is not used.
Type | Function |
|---|---|
Date/time functions | age(timestamp) current_date current_timestamp current_time localtime localtimestamp |
Session information functions | current_user current_role |
Action method
To use VCI, specify the second argument when using the age function, and specify other functions as subqueries.
[Example]
Before: select age(column A), current_date from table
After: select age(column A, now()), (select current_date) from table
