DateTime Format #2

[RMcB]

Hello!

I have a column named "RS_RECORDED_DATETIME" with a custom format mm/dd/yyyy hh24:mi:ss. I need to remove the leading 0 in the hours output (see attached picture).

Please send any solutions you might have.  

Thank you!

[bpatel · Accepted solution]

hi @RMcB ,

you can use regex to parse out 0. hope this helps