TRUNC - Truncate Datetime

In Oracle, TRUNC(datetime, unit) function allows you to truncate a datetime value to the specified unit (set zero time, set the first day of the month i.e).

Oracle:

  -- Get current datetime with the time set to zero (returns: 2012-07-13 00:00:00)
  SELECT TRUNC(SYSDATE) FROM dual;

TRUNC Function Overview

Oracle TRUNC for datetime:

Syntax	TRUNC(datetime [, unit])
Default Unit	'DD' truncates to day (sets zero time)

TRUNC function supports the following truncation units (full list...):

Oracle TRUNC Unit		Truncation	Result
'DD'	'DDD'	Day	YYYY-MM-DD 00:00:00
'MM'	'MONTH'	Month	YYYY-MM-01 00:00:00
'YY'	'YEAR'	Year	YYYY-01-01 00:00:00
'HH'	'HH24'	Hour	YYYY-MM-DD HH:00:00
'MI'		Minute	YYYY-MM-DD HH:MI:00

SQLines Services

SQLines offers services to migrate Oracle databases and applications to Microsoft SQL Server. For more information, please Contact Us.

You could leave a comment if you were logged in.

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to SingleStore

Migration to IBM DB2

Migration to Redshift

Migration to Snowflake

Migration to Apache Hive

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to EsgynDB

Application Conversion

Database Reference

TRUNC - Truncate Datetime

TRUNC Function Overview

SQLines Services