How to transfer specific number to date in PostgreSQL?

Question

Need to transfer numeric columns with numbers like '201 711' and '201 806' to dates like '2017-11-01' and '2018-06-01' ('YYYY-MM-01'). When I try this

select to_date(debt_max_period,'YYYY-MM') as date1 from debt;

I get

SQL Error [42883]: ERROR: function to_date(numeric, unknown) does not exist.

Will be thankful for any ideas!

user330315 · Accepted Answer · 2020-07-13 06:09:36Z

1

You need to cast the number to a text/varchar value. As the number doesn't contain the - character, you also need to remove that from your format mask.

to_date(debt_max_period::text, 'yyyymm')

answered Jul 13, 2020 at 6:09

user330315

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

Comments

buddemat · Accepted Answer · 2023-02-04 10:29:41Z

0

Oracle -

select TO_CHAR(TO_DATE(START_DATE,'YYYYMMDD'),'YYYY-MM-DD') STARTDATE from account

You can use like below as well. Postgresql -

select TO_CHAR(TO_DATE(START_DATE::text,'YYYYMMDD'),'YYYY-MM-DD') STARTDATE from account

edited Feb 4, 2023 at 10:29

buddemat

5,33016 gold badges37 silver badges61 bronze badges

answered Feb 1, 2023 at 5:51

Parameshwar

1

Collectives™ on Stack Overflow

How to transfer specific number to date in PostgreSQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related