TARGIT Community
Documentation
Data Warehouse: TARGIT InMemory
Function Overview

TRUNC (date)

Ole Dyring

February 17, 2021 08:38

Removes the time part from a date. The example below shows a date column generated from the current
server date and time (GETDATE) and the TRUNC'd VALUE.

Example:

SELECT GETDATE() as CurrentDateWithTimeStamp, TRUNC(GETDATE()) AS TruncDateOnly 

/* Returns the table 
CurrentDateWithTimeStamp TruncDateOnly 
6/3/2016 9:42 AM         6/3/2016 
*/

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

ABS (number)
ACOS (number)
ASCII (char)
ASIN (number)
ATAN (number)
ATAN2 (number1, number2)
AVG (expression)
CAST (expression)
CAST_NUM_AS_BYTE (number)
CAST_NUM_AS_DECIMAL (number)