In Oracle there are two usefull function to format a timestamp to string and vceversa…. To format a date to string you can use TO_CHAR function like this: SELECT TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI:SSxFF’) from dual; For viceversa To format a string to date you can use TO_ function like this: SELECT TO_DATE(‘2003/07/09’, ‘yyyy/mm/dd’) from dual; The…
Leggi tutto
