Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Date value calculation in to_char function

SQL> SQL> SQL> select to_char(date '1954-08-11' + 10000,'Day')   2         as "On a:"   3  from   dual; Enter... Zondag 1 row selected. SQL>