|
|
| Re: Diff between Sysdate and DBdate [message #126628 is a reply to message #126410] |
Wed, 06 July 2005 00:56  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
| Quote: |
Date and Time System Default Values
Form Builder supplies six special default values $$DATE$$, $$DATETIME$$, $$TIME$$,
$$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ that supply date and time information. These
variables have the following special restrictions on their use:
For client/server applications, consider the performance implications of going across the network to get
date and time information.
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.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
