Date problem

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.

With Thankswhen you got that error message, it was most likely because you did not specify a column list for the INSERT statement

let's say your table has five fields, and you add a sixth one

in order for the default getdate() value to work, you have to sayinsert
into annouce
( fld1, fld2, fld3, fld4, fld5 )
values
( 1, 2, 3, 4, 5 )this way the number of supplied values equals the number of columns you are inserting into

the column you did not mention in the insert statement is then given its default value

rudy
http://r937.com/sql