Search code examples
sqloracle-databaseoracle9i

How to delete datetime value using update?

I have a row with datetime. What I want to achieve is delete the datetime in just a blank. Is that possible with using update? If possible I don't want to delete and re-insert the data because this is what I tried and it so inefficient.

Here is my table:

+++++++++++++++++++++++++++++++++++++
+ ID  + Name +        AppvlDt       +
+++++++++++++++++++++++++++++++++++++
+  1  +  JB  +  02/11/2019 00:00:00 +
+++++++++++++++++++++++++++++++++++++

I want to delete the AppvlDt into just a plain blank. Is that possible using Update?

Solution

  • You can certainly null out your datetime field, e.g.

    UPDATE yourTable
SET AppvlDt = NULL
WHERE ID = 1;

    Whether or not doing this actually makes sense depends on other things though.