Question
Infosys
AU
Last activity: 12 Feb 2018 3:59 EST
HOW TO CONVERT DATETIME TO DATE IN REPORT DEFINITION
Hi,
I want to convert datetime say current datetime to date(need date part only). Not able to do via function alias also, can someone help me on this.
Thank in advance.
***Moderator Edit: Vidyaranjan | Updated Categories***
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Infosys
AU
getting this error while executing function alias:
to_timestamp(date, unknown) does not exist
OCBC
SG
Hi Madhusudan,
Please refer below images.
Use configuration icon in column to configure date format.
-
Preethi Ageer Venkat Raman Malaiarasan Shane Soderstrom Varsha Junuthula Rahul Choudhary and 1 More
Infosys
AU
Thanks Thenzun, but I am actually taking difference of two datetime value...which is giving me results by calculating time also but I need it to calculate only the days, meaning if I compare todays date and yesterday date difference should be one but it is taking time parameter also and if the difference is < 24 it is returning 0.Please see the attachment where I am using function where in these two parameters are of date time type. so I need to convert these two into dates and then find the difference.
Thanks again.
Infosys
AU
any one can help me on that?
Pegasystems Inc.
US
HI Madhu,
I had tried the similar use case in Pega 7.2.2 environment and it is returning the value 1 even though difference is <24 hr as shown in attachment.
Regards
Mahesh
-
Preethi Ageer
Infosys
AU
Thanks Mahesh.
That means this function is working absolutely fine in your case. I mean it is taking server's timezone and calculating accordingly?
Pegasystems Inc.
US
yes it is from my local environment.