Empty Date
Hi All,
I have imported into a table the following (truncated);
CHECK_NUM,BOOK_NUM,PAT_ID,CHECK_OUT_DATE,CHECK_DUE_DATE,CHECK_IN_DATE
91059,5249,1207,2015-05-10,2015-05-17,
91060,5235,1209,2015-05-15,2015-05-22,2015-05-18
91061,5246,1172,2015-05-15,2015-05-22,
91062,5254,1223,2015-05-15,2015-05-22,2015-05-16
91063,5243,1223,2015-05-15,2015-05-22,2015-05-20
91064,5236,1183,2015-05-17,2015-05-31,2015-05-21
91065,5244,1210,2015-05-17,2015-05-24,2015-05-17
91066,5242,1228,2015-05-19,2015-05-26,
91067,5252,1229,2015-05-24,2015-05-31,
91068,5238,1229,2015-05-24,2015-05-31,
Now I want to fill the CHECK_IN_DATE with NULL;
Code:
UPDATE CHECKOUT
SET CHECK_IN_DATE = null
WHERE CHECK_IN_DATE = 0000-00-00;
I have also tried 'yyyy-mm-dd','', and ' ', however I do not know what this empty value is, can anyone tell me?
Cheers TC