Formatting date in the format (mm dd yy hh mm AM/PM)

Technical queries
, , , ,
#1

Hello Helical Insight,

Hello. I am using Helical Insight version 4 Enterprise edition. I am creating reports with date time data, I would like to format the date fields in the format format (mm dd yy hh mm AM/PM), how can that be done? I am using Trino

Thank You,
Vema.

#2

Hello Vema,

In order to do this you can either use custom column or in the format function (from one db to another DB this syntax might change also
date_format("appealsdata"."appeal_verdict_date",'%m-%d-%y %h:%m %p')
When the above is done it will appear like below

image

Thank You,
Helical Insight.