Logo Background

Oracle Date To Day Conversion

  • By on August 22, 2008 | No Comments

    The SQL below is useful to help you on doing conversion from date to day based on sysdate or any given date input: –

    Conver Date To Day SQL

    a) select to_char(sysdate,’DAY’) from dual;

    b) select to_char(sysdate,’DY’) from dual;

    c) select to_char(sysdate,’D’) from dual;

    » Unix TAR Archive Command
Leave a Comment