Organizational Research By

Surprising Reserch Topic

Question:What is the correct use of the Trunc command on a date?


a.        TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;
b.        Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;
c.        Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;
d.        SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
42 views



Related Hot Questions



Government Jobs Opening


...