You can translate the question and the replies:

How to remove leading zero's in date time stamp

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help
26-09-2020 16:42:40 -0400

1 Answer

Hi, You can use the regexp funtion to make the transformation: `regexp('08/03/2017 04:48:34 PM','\b0','')` You may refer to the section [REGEXP]( in the Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
29-09-2020 05:57:13 -0400
You must sign in to add an answer. If you do not have an account, you can register here