How to insert empty date into postgres

Question

I have a column that requires a timestamp with time zone but I cannot use a built in pgSQL function nor can I modify the column to accept null dates. How can I insert a string date in the right format manually that represents no time?

klin · Accepted Answer · 2018-06-16 10:46:58Z

8

There is no empty timestamp other than null, but you can use one of the special date/time values infinity or -infinity.

select 'infinity'::timestamp, '-infinity'::timestamp

 timestamp | timestamp 
-----------+-----------
 infinity  | -infinity
(1 row)

See Table 8.13. Special Date/Time Inputs.

edited Jun 16, 2018 at 10:46

answered Jun 15, 2018 at 23:26

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

How to insert empty date into postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related