truncate dates in sql code example
Example 1: sql truncate table
-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;
Example 2: trunc in sql
TRUNC function returns a date truncated
to a specific unit of measure.
TRUNC function returns a date truncated
to a specific unit of measure.