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
Date time function
user
26-09-2020 16:42:40 -0400
code

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](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#regexp) in the Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
29-09-2020 05:57:13 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here