Oracle Forms provides six special system variables:
- $ DATE $
- $ TIME $
- $ DATETIME $
- $ DBDATE $
- $ DBTIME $
- $ DBDATETIME $
Among them, $ DATE $, $ TIME $, $ DATETIME $ three system variables can be used to get users
Client Operating SystemThe current date and time. $ DBDATE $, $ DBTIME $, $ DBDATETIME $ three system variables can be obtained
Server where the database system is locatedThe current date and time. UsageGenerally, these six system variables can be used FillThe following three attributes of a data ITEM on a data BLOCK
- Initial Value (Initial Value )-This is the most common
- Highest Allowed Value (maximum Allowed Value)
- Lowest Allowed Value (minimum Allowed Value)
Notes
- When the target data source is a non-ORACLE database, avoid using $ DBDATE $, $ DBTIME $, $ DBDATETIME $. we recommend that you use the method specified by the data source in the WHEN-CREATE-RECORD trigger to obtain the current time using an SQL statement.
- Do not forget that the $ DATE $ series variables take the current time on the client operating system, and $ DBDATE $ series variables get the current time in the target database. For example, if you remotely log on to a server system and the time zone of the server is different from the time zone of your server, the values of the two may be different.
