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***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

February 4, 2018 - 11:10am

getting this error while executing function alias:


 to_timestamp(date, unknown) does not exist

February 4, 2018 - 1:31pm

Hi Madhusudan,

Please refer below  images.

Use configuration icon in column to configure date format.

February 4, 2018 - 1:57pm
Response to Thenuzan

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.


February 9, 2018 - 9:37am

any one can help me on that?

February 9, 2018 - 11:14am
Response to MadhusudanS9253

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.



February 11, 2018 - 3:14am
Response to Mahesh Midthuru

Thanks Mahesh.


That means this function is working absolutely fine in your case. I mean it is taking server's timezone and calculating accordingly?

February 12, 2018 - 3:59am
Response to MadhusudanS9253

yes it is from my local environment.