|
SQL>
SQL> –Truncates 7:45:26 P.M. on May 25, 2005, to the hour
SQL>
SQL> SELECT TO_CHAR(TRUNC(TO_DATE(‘25-MAY-2005 19:45:26‘,’DD-MON-YYYY HH24:MI:SS‘), ’HH24‘), ’DD-MON-YYYY HH24:MI:SS‘) FROM dual;
TO_CHAR(TRUNC(TO_DAT
——————–
25-MAY-2005 19:00:00
SQL>
|
Tags: 2005, 26 PM on May 25, 45, Code, Date Timezone, Oracle PL / SQL, to the hour, TRUNC Date, TRUNC Date laquo Date Timezone laquo Oracle PL SQL, Truncates 7
Posted in Uncategorized |
This entry was posted
on Sunday, July 12th, 2009 at 7:10 am and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
