Tag Archives: January

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default

You need to calculate the number of days from 1st January 2019 until today.Dates are stored in the default format of DD-MON-RR.Which two queries give the required output? (Choose two.) A. SELECT ROUND(SYSDATE ?’01-JAN-2019′) FROM DUAL; B. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY’) ?`01/JANUARY/2019′ FROM DUAL; C. SELECT SYSDATE ?TO_DATE(’01-JANUARY-2019′) FROM DUAL; D. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY’) ?’01-JAN-2019′ FROM DUAL; E. SELECT… Read More »

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default

You need to calculate the number of days from 1st January 2019 until today.Dates are stored in the default format of DD-MON-RR.Which two queries give the required output? (Choose two.) A. SELECT ROUND(SYSDATE – TO_DATE(’01/JANUARY/2019′)) FROM DUAL; B. SELECT ROUND(SYSDATE – ’01-JAN-2019′) FROM DUAL; C. SELECT SYSDATE – TO_DATE(’01-JANUARY-2019′) FROM DUAL; D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ’01/JANUARY/2019′ FROM… Read More »