CONVERSION functions: Print the current date/time as a character string and modifies the format : TO_CHAR « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. TO_CHAR

CONVERSION functions: Print the current date/time as a character string and modifies the format

   
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2     v_sysdate DATE := SYSDATE;
  3     v_date DATE;
  4     v_char VARCHAR2(20);
  5  BEGIN
  6
  7
  8     
  9     v_char := TO_CHAR(v_sysdate, 'DD:MM:YYYY HH24:MI:SS');
 10     DBMS_OUTPUT.PUT_LINE('Display as CHARACTER DD:MM:YYYY HH24:MI:SS: '||v_char);
 11
 12
 13  END;
 14  /
Display as CHARACTER DD:MM:YYYY HH24:MI:SS: 26:10:2009 10:41:36

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.The TO_CHAR() function converts the expression into character data.
2.Pass variable into to_char function
3.Use to_char function to init an text value
4.convert a negative number into one with a trailing "minus sign,"
5.to_char(bdate,'fmMonth ddth, yyyy')
6.to_char(round(sqrt(sal),2),'9999.99')
7.to_char(sysdate, 'Day', 'nls_date_language=Dutch')
8.to_char(sysdate,'DAY dy Dy') as day, to_char(sysdate,'MONTH mon') as month
9.to_char(sysdate,'hh24:mi:ss') as time