|
|
| Re: Can we use windows date instead of sysdate [message #132332 is a reply to message #132329] |
Thu, 11 August 2005 23:28  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
From the 9i Forms documentation there is:| Quote: |
Date and Time System Default Values
Forms Developer supplies six special default values $$DATE$$, $$DATETIME$$, $$TIME$$, $$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ that supply date and time information.
These variables have the and the following special restrictions on their use:
- When accessing a non-ORACLE datasource, avoid using $$DBDATE$$ and $$DBDATETIME$$. Instead, use a When-Create-Record trigger to select the current date in a datasource-specific manner.
- Use $$DATE$$, $$DATETIME$$, and $$TIME$$ to obtain the local system date/time; use $$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ to obtain the database date/time, which may differ from the local system date/time when, for example, connecting to a remote database in a different time zone.
- Use these variables only to set the value of the Initial Value, Highest Allowed Value or Lowest Allowed Value property.
|
Then look at WebUtil
| Quote: |
5.3.1 WebUtil_ClientInfo
WebUtil_ClientInfo contains functions to obtain information about the client machine:
Get_Date_Time - Returns a PL/SQL date containing the date and time on the client machine.
|
Also look at the newer timezone capabilities of 9i and 10g DB if you are using those versions.
David
[Updated on: Thu, 11 August 2005 23:30] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
