New SQL Functions
The following new functions have been added.
Date and time functions:
• TIMESTAMPADD
• TIMESTAMPDIFF
• INTERVAL_DIFF
• SYSDATE
Conversion functions:
• TO_CHAR(datetime)
• TO_DATE
IP network address functions:
• INET_PTON or IPV4
• INET_NTOP or IPV6
• INET6_PTON
• INET6_NTOP
• Bitwise functions that operate on IPV4 or IPV6 addresses
Aggregate functions:
• GROUPING
• COUNT_BIG
For details, see the Ingres SQL Reference Guide.