Siemens Sinumerik 840D sl Function Manual page 56

DNC Plant/DNC Cell (FBDN1)
3 Operator interface
Filtering by date in Oracle databases
Fig. 3-21: Filter Criteria dialog for date in Oracle databases
Note
The date format depends on the setting in the database. For this reason, the date
must be entered in the format required by the database since it cannot be
converted.
Example 1: "Change date > sysdate - 2"
The sysdate function allows the current date to be output in Oracle. The filter
criterion Change date > sysdate - 2 returns all the DNC data records whose
change date is no more than two days ago. The sysdate function allows the system
to filter data on a relative basis, e.g. according to changes made over the past few
days (two days in the example provided here). This means that you do not have to
specify an absolute date in a particular date format.
Example 2: "Change date > 2007-03-23"
In this example, all the programs whose change date is after 03/23/2007 are
displayed. The correct date format must be observed here. The default setting in
Oracle is the ISO format:
YYYY-MM-DD. The format should be checked beforehand when this filter criterion
is used. It is based on the settings for the Oracle parameter NLS_DATE_FORMAT,
which is set by the database client.
FBDN1/3-48
© Siemens AG 2010 All Rights Reserved
Motion Control Information System DNC (FBDN) - 04/10 Edition
05.07