I need help with converting datetime20. to a character.
The format of the data is as follows:
18AUG2022:13:41:10
I need to convert it to character because I am concatenating this field with another character field.
In that case you probably do not want to use DATETIME format. Instead use something like E8601DT19. that will generate a string that will sort in chronological order.