Ejemplo 1: fecha actual de Oracle
-- In SESSION time zone
SELECT current_timestamp FROM dual; -- 2021-05-07 05:36:57.476000
SELECT current_timestamp(2) FROM dual; -- 2021-05-07 05:36:57.470000
SELECT current_date FROM dual; -- 2021-05-07 05:36:57
-- In SYSTEM on which database resides
SELECT systimestamp FROM dual; -- 2021-05-07 07:36:57.762000 +02:00
SELECT sysdate FROM dual; -- 2021-05-07 07:36:57
Ejemplo 2: fecha actual de Oracle sin hora
SELECT trunc(sysdate) FROM dual; -- returns a DATE 01/12/2021 00:00:00
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)