New and changed functions in Adaptive Server 15.5
| Function | Description |
|---|---|
| db_attr | Returns the durability, dml_logging, and template settings for the specified database. |
| object_attr | Reports the table’s current logging mode, depending on the session-specific, table-wide, and database-wide settings. |
| cache_usage | Returns cache usage for the cache to which the specified object is bound, as the percentage of the cache which is currently in use by all objects bound to that cache. |
| current_bigdatetime | Returns a bigdatetime value representing the current date and time with microsecond precision. |
| current_bigtime | Returns a bigtime value representing the current time with microsecond precision. |
| Function | Description | |
|---|---|---|
| datepart | Produces the specified datepart argument of the specified date as an integer. | |
| datename | Produces the specified datepart as a character string. | |
| datediff | Calculates the number of date parts between two specified dates or times. | |
| dateadd | Adds an interval to a specified date or time. | |
See the Reference Manual: Commands.