| How To Trunc Date In Oracle [message #642828] |
Mon, 21 September 2015 06:28  |
 |
swti6690
Messages: 1
Registered: September 2015
Location: Louis velle
|
Junior Member |
|
|
The TRUNC meaning can utilized to around a dateTime charge downward to a bold granularity. Since the accuracy of DATE is to the second (& no portions of seconds), there is no require to TRUNC at the entire. The Oracle/PLSQL TRUNC purpose revisits a date truncated to a detailed component of compute.
[Edit MC: link removed and you don't lose anything but save time not reaching it.]
[Updated on: Mon, 21 September 2015 07:02] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: How To Trunc Date In Oracle [message #642832 is a reply to message #642831] |
Mon, 21 September 2015 06:52  |
 |
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I vote for the second part of the question. 
Site which is bad:
SQL> SELECT TRUNC (TO_DATE('20-MAY-2002'), 'YYYY') FROM dual;
SELECT TRUNC (TO_DATE('20-MAY-2002'), 'YYYY') FROM dual
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
Quote:there is no require to TRUNC at the entire
What does that mean?
Quote:The Oracle/PLSQL TRUNC purpose revisits a date truncated to a detailed component of compute.
And this? "a detailed component of compute"? what is this?
[Updated on: Mon, 21 September 2015 06:53] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
