Download Mimer SQL Reference Manual - Department of Information Technology
Transcript
Deprecated features D.6 D-5 Datetime scalar functions The following scalar functions have been deprecated in the current version of Mimer SQL. They will be re-introduced in a future version with changed functionality. D.6.1 CURRENT_TIME This function, in its present form, has been deprecated. The same functionality is now provided by the LOCALTIME function. Continued use of CURRENT_TIME is not recommended as the function will be re-introduced, with changed functionality, in a future version of Mimer SQL and thus existing usage will not be forward-compatible. D.6.2 CURRENT_TIMESTAMP This function, in its present form, has been deprecated. The same functionality is now provided by the LOCALTIMESTAMP function. Continued use of CURRENT_TIMESTAMP is not recommended as the function will be reintroduced, with changed functionality, in a future version of Mimer SQL and thus existing usage will not be forward-compatible. D.7 Data dictionary views The predefined system views on the data dictionary tables, owned by the system ident called MIMER, that were supported in previous versions of Mimer SQL have now been replaced by the standard system views belonging to the schemas INFORMATION_SCHEMA and INFO_SCHEM which are owned by ident SYSTEM. Mimer SQL version 8.2 Reference Manual