How to escape a colon in Data Explorer?

data & reporting
1

In Data Explorer, I’m trying to cast a date using TO_CHAR(p.created_at, 'HH:MI:SS DD/MM/YY') but the parser thinks that :MI is a parameter. Is there a way to escape the colon? I’ve tried \: but it doesn’t work. :: makes the error go away, but both colons show up.

1 Like
2

There’s probably another way to get it to work, but you could try:

TO_CHAR(created_at, CONCAT('HH', ':', 'MI', ':', 'SS', ' DD/MM/YY'))
3 Likes