Erik 4, 4 4 gold badges 23 23 silver badges 56 56 bronze badges. Juan Velez Juan Velez 3, 13 13 gold badges 48 48 silver badges 67 67 bronze badges. You're mixing data types up too much. What data type is DOB? Add a comment. Active Oldest Votes. Improve this answer. This will convert the NULL date to space. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Posted Jan am Member Updated Jan am Deepu S Nair.
Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution. Posted Jan am CPallini. MySqlConnect My. Connection MySqlCmd. Parameters " ID". DateTime MySqlCmd. Parameters " Date". Null MySqlCmd. Text MySqlCmd. ExecuteNonQuery Me. Posted 9-Feb pm Member Add your solution here.
OK Paste as. Treat my content as plain text, not as HTML. Login to reply. October 20, at am Hi, I want to insert blank value in my table for datatime column. I am getting for blank value? So please tell me how it will work? Wilfred The best things in life are the simple things. I want my result like that : insert into t1 date values '' it should show with no value or null date.
October 24, at am
0コメント