Hi there !
Can anyone tell me how to convert 1900-01-01 00:00:00 into current date and current time. ?
I am just one the beginer of MSSQL and ASP. I have a table name annouce which work fine before i altered it. I added one new field named tdate whcih has datetype smalldatetime & have default value getdate().
When not provide the any value when inserting a new row, I got the error "Column name or number of supplied values does not match table definition. " which is true because the number of supplied value is 1 less then number of column. But then what does the default value meant for ?
When i provide NULL means( " ") then it automatically add the above mention date and time. ?
Can anyone put some light why it happend ? Shall, i have to put all the fields name except the new added field ? or i have to do something else.