Convert date to specific format in postgresql

Question

I have a column with values as below .Data type is 'Text'

 Check-in

 26Nov2017
 09Jun2017
 19Jan2018

I am trying to convert into specific format

Check-in

Nov-17
Jun-17
Jan-18

I am getting type explicit error when i try writing as

 select Check-in,to_date(Check-in,'Mon-YY') as Check-in_updated from my_table;

S-Man · Accepted Answer · 2018-10-01 06:45:36Z

2

First you need to convert it into date explicitly using CAST()

SELECT TO_CHAR(cast(Check-in as date), 'Mon-YY')

Output:

Nov-17

S-Man

24k9 gold badges51 silver badges78 bronze badges

answered Oct 1, 2018 at 4:18

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1