enhance IntelliSense of hql-editor
nimo22 Sep 2, 2010 3:58 AMI have found out that the intellisense of hql-editor does not contain all sql-statements.
For example: SQL Date and Time Functions (adapted from http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html)
DAYNAME | Returns a mixed case character string containing the name of the day (e.g., Friday) for the day portion of the argument. |
DAYOFWEEK | Returns the day of the week in the argument as an integer value in the range 1-7, where 1 represents Sunday. |
DAYOFWEEK_ISO | Returns the day of the week in the argument as an integer value in the range 1-7, where 1 represents Monday. |
DAYOFYEAR | Returns the day of the year in the argument as an integer value in the range 1-366. |
DAYS | Returns an integer representation of a date. |
JULIAN_DAY | Returns an integer value representing the number of days from January 1, 4712 B.C. (the start of Julian date calendar) to the date value specified in the argument. |
MIDNIGHT_SECONDS | Returns an integer value in the range 0 to 86 400 representing the number of seconds between midnight and the time value specified in the argument. |
MONTHNAME | Returns a mixed case character string containing the name of month (e.g., January) for the month portion of the argument. |
TIMESTAMP_ISO | Returns a timestamp value based on date, time or timestamp argument. |
TIMESTAMP_FORMAT | Returns a timestamp from a character string that has been interpreted using a character template. |
TIMESTAMPDIFF | Returns an estimated number of intervals of the type defined by the first argument, based on the difference between two timestamps. |
TO_CHAR | Returns a character representation of a timestamp that has been formatted using a character template. TO_CHAR is a synonym for VARCHAR_FORMAT. |
TO_DATE | Returns a timestamp from a character string that has been inter-preted using a character template. TO_DATE is a synonym for TIMESTAMP_FORMAT. |
WEEK | Returns the week of the year of the argument as an integer value in range 1-54. The week starts with Sunday. |
WEEK_ISO |
I guess, these are sql-functions independent from the database-provider. So would be nice to adapt these into the intellisense from hql-editor.