Soal Basis Data Oracle Date Functions

Lihat Soal Basis Data Oracle Date Functions - Soal Basis Data Oracle Date Functions Berikut adalah soal latihan basis data oracle mengenai date function dengan jawaban lengkap.



1. Which query would return a whole number if the sysdate is 26/MAY/2004?

SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19/MAR/1979') /12) AS YEARS FROM DUAL;



2. Round and Trunc cannot be used on Date datatypes. True or