INFOMRIX ORACLE
Month (date_expr) to_number (to_char (date_expr, 'mm')) Returns the respective month
Time to_char (sysdate, 'hh24: mi: ss') Returns the current time
Today sysdate Returns the current system time
Weekday (date_expr) TO_NUMBER (TO_CHAR (DATE_EXPR, 'D') - 1) Returns the specified date is the day, 0 table
Sunday
Year (DATE_EXPR) TO_NUMBER (TO_CHAR (DATE_EXPR, 'YYYY') Returns the specified date corresponding
Str [Index1, Index2] Substr (Str, Index1, LEN) INDEX1 and INDEX2 must be often used in Informix
Quantity, and Oracle Index1, len can be variables
DOWNSHIFT (STR) Returns uppercase string
UPSHIT (STR) UPPER (STR) Returns uppercase string
Length (STR) Length (STR) returns the length of the string
Current sysdate Returns the current date and time
Date ("12/13/1999") to_date ('12/13 / 1999 ',' mm / dd / yyyy ') Returns the specified format date
Day (DTIME_EXPR) TO_NUMBER (To_CHAR (DD ')) Returns the first few days of the specified date
Extend (Value [, first to last] to_date (to_char (value, 'formate-mask') Adjust the date-time accuracy
