Convert timestamp in PostgreSQL

Question

I want to convert timestamp column to the following format in PostgreSQL:

2/28/2018

I've tried:

to_char((sr.created_at), 'MM/DD/YYYY')

but that gives me:

02/28/2018

Is there way to do that in PostgreSQL?

What do you want for 1st Jan 2019? 1/1/2019 or 1/01/2019 ? — Kaushik Nayak
– Kaushik Nayak, Commented Dec 7, 2018 at 7:51

Kaushik Nayak · Accepted Answer · 2018-12-07 07:58:59Z

5

You may use the FM prefix to suppress leading zeroes.

knayak=# select TO_CHAR(DATE '2019-01-01','FMMM/FMDD/YYYY');
 to_char
----------
 1/1/2019
(1 row)

answered Dec 7, 2018 at 7:58

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

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

1 Answer 1