RosettaCodeData/Task/Date-format/SQL/date-format.sql

4 lines
130 B
SQL

select to_char(sysdate,'YYYY-MM-DD') date_fmt_1 from dual;
select to_char(sysdate,'fmDay, Month DD, YYYY') date_fmt_2 from dual;