Siemens ET 78X Series Instructions d'exploitation Page 57

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 349
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 56
05.07 DNC Plant/DNC Cell (FBDN1)
3 Operator interface
© Siemens AG 2010 All Rights Reserved
Motion Control Information System DNC (FBDN) - 04/10 Edition
FBDN1/3-49
Example 3: "Change date > 2007-03-23 12:30:00"
In this example, all the programs whose change date is after 03/23/2007 12:30:00
are displayed. The correct date format must be observed here. The default setting
in Oracle is the ISO format: YYYY-MM-DD HH24:MI:SS. 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.
Example 4: "Change date > to_date('23.03.2007','DD.MM.YYYY')"
In this example, all the programs whose change date is after 03/23/2007 are
displayed. The to_date function also allows the specified date format to be
explicitly communicated to the database. The benefit here is that the entry is
independent of the preset formats. In some cases, the system may not return any
hits if the format has been entered incorrectly.
Note
This function should also be used when the system filters according to an
absolute date if the filter is created for both DNC HMI and DNC IFC SINUMERIK.
They can be applied universally in this form (as with the sysdate functions).
Vue de la page 56
1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 348 349

Commentaires sur ces manuels

Pas de commentaire