Details
-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
This function is commonly used in Oracle PL/SQL or queries to truncate various data types for instance;
1. TRUNCATE a fraction from a number
2. TRUNCATE a timestamp portion of a date/datetime/timestamp values
TRUNC(DATE/DATETIME/TIMESTAMP): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions201.htm
TRUNC(NUMBER): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm