Helical Insight 5.0 extracting date from datetime

Adhoc
, ,
#1

Hello Team,

I am using TRINO with Helical Insight 5.0. I want to extract date from date time field. How can i achieve this ?

Thank you.

#2

Hello Team,
There are 2 ways using which we can do this.

  1. Using custom column :
    Create a custom column and paste below line :

DATE_FORMAT("TABLENAME"."COLUMNANE",'%Y-%m-%d')

Change the table name and column name with whatever you want.

image

OUTPUT :

image

  1. Using DB function (In built function) :
    You can get same output using inbuilt db function called FORMAT
    FORMAT(COLUMNAME,'%Y-%m-%d')

image

OUTPUT :

image

Thank you,
Helical Insight.