Snowflake date format change

Question

Is there an easy way convert a date format from ('2020-11-17') to November 17,2020 in snowflake.

Thanks

`Nov` is easier than `November` - would that work? – Felipe Hoffa Nov 18 '20 at 05:47 — Felipe Hoffa, Nov 18 '20 at 05:47
in my case it should be full month name ( November) – Zoom Nov 18 '20 at 05:48 — Zoom, Nov 18 '20 at 05:48

score 1 · Answer 1 · answered Nov 18 '20 at 16:26

1

You should consider using:

TO_CHAR(date, 'MMMM DD yyyy')

answered Nov 18 '20 at 16:26

Onyambu

score 0 · Answer 2 · edited Nov 18 '20 at 08:35

0

I SOLVED THIS PROBLEM USING BELOW SYNTAX:

TO_CHAR(date,'MMMM')||' '||TO_CHAR(date,'DD')||','||TO_CHAR(date,'yyyy')

edited Nov 18 '20 at 08:35

Ahmed

answered Nov 18 '20 at 07:17

Zoom

1

did you try `TO_CHAR(date, 'MMMM DD yyyy')`?? – Onyambu Nov 18 '20 at 09:16
@Onyambu . . . You should add that as an answer so it can at least be upvoted. – Gordon Linoff Nov 18 '20 at 13:29
@Onyambu, the format i needed was different from your answer. – Zoom Nov 18 '20 at 16:39
@zoom what does this give? – Onyambu Nov 18 '20 at 16:44

2 Answers2