Postgresql : set timestamp to null

Question

I have searched across SO related questions, but I couldn't find the solution for :

How to set timestamp to NULL during an insert to DB or an update ? (in postgresql).

If I put NULL like pstat.setTimestamp(idx++, null); I get an error which says that the type I put in is integer and that I should cast to Timestamp.

As definition for this table column, I use : ADD COLUMN admin_validation_date timestamp with time zone

Thank you for your help.

user330315 · Accepted Answer · 2013-04-26 13:50:08Z

3

pstat.setNull(idx++, Types.TIMESTAMP);

should do it.

answered Apr 26, 2013 at 13:50

user330315

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

Collectives™ on Stack Overflow

Postgresql : set timestamp to null

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