How do I create a specific date in PostgreSQL?

Question

I need to execute a INSERT statement writing a date with a YYYY-MM-DD format.

Would to_date('2021-09-28','YYYY-MM-DD') work?

date values do not have "a format". So it's completely irrelevant if you use to_date('2021-09-28', 'yyyy-mm-dd') or to_date('28.09.2021', 'dd.mm.yyyy') — user330315
– user330315, Commented Oct 5, 2021 at 13:22

Erwin Brandstetter · Accepted Answer · 2021-10-06 00:57:21Z

2

YYYY-MM-DD is the the ISO 8601 standard date format and unambiguous default in Postgres. Just insert your date literally.

The type date is stored as a 4-byte integer quantity internally, which does not preserve any format. You can format any way you like on output with some basic locale settings or settings of your client, or explicitly with to_char().

Input with to_date('2021-09-28','YYYY-MM-DD') works, too. But you don't need to_date() while operating with ISO format.

edited Oct 6, 2021 at 0:57

answered Oct 5, 2021 at 13:38

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

How do I create a specific date in PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related