Combining TO_CHAR to Format SYSDATE : SYSDATE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SYSDATE

Combining TO_CHAR to Format SYSDATE

 
SQL>
SQL> SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH:MM:SS AM')
  2        "Today's Date and Time" from DUAL;
Today's Date and Time
----------------------
06/16/2008 06:06:07 PM

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.select sysdate
2.Using the SYSDATE function: return the current date from the system
3.Get current operating system date
4.Removing the Time from SYSDATE
5.Truncating to the Quarter
6.Adding Two Months to SYSDATE
7.Adding One Month a certain date
8.Finding the First Monday After the Current Date and Time
9.use sysdate to init a variable
10.Minus days from sysdate