You can translate the question and the replies:

How to remove leading zero's in date time stamp - 08/03/2020 04:05:15 PM

Hi Team\ I have format date 08/03/2020 04:05:15 PM want to remove the leading zero only on the date given above . How to do that.. Please help, its very urgent to implement on the job design. 08/03/2020 04:05:15 PM o/p 8/3/2020 04:05:15 PM
user
29-09-2020 08:21:37 -0400

1 Answer

Hi, I was able to use the [**REGEXP**](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#regexp) for removing the leading zeros from the date value. You can take a look at a similar [**Q&A**](https://community.denodo.com/answers/question/details?questionId=9064u000000CewrAAC&title=How+to+remove+leading+zero%27s+in+date+time+stamp) for more information. Hope this helps!
Denodo Team
30-09-2020 04:32:47 -0400
You must sign in to add an answer. If you do not have an account, you can register here