Aktuelles Datum/Uhrzeit

ID216
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangORACLE PL/SQL
PlGroupDatum, Zeit
PlItemTitleAktuelles Datum/Uhrzeit
Code-- if todays date is: 2014-02-02 then a static query would be
SELECT TO_DATE('02/02/2014','dd/mm/yyyy') FROM dual

-- system variable
SELECT SYSDATE AS TODAY FROM SYS."DUAL"
Result Example