Removing the Time from SYSDATE : SYSDATE « Date Timezone « Oracle PL / SQL






Removing the Time from SYSDATE

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

1 row selected.

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.Combining TO_CHAR to Format 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