Coldfusion how to put todays date and time in microsoft sql?

Question

Hey Everyone,

I was just wondering if anyone knew how to put the current date and time

into a sql database? i tried using getDate() an put it as a default value for my date field but it still displays 1/1/1900 12:00:00 AM. Any suggestions?

Thank you in advance,

Rach

Answer 1

Try this

create table #T(id int, dt datetime default getdate())

go

insert into #T(id) values(1)

go

select * from #T

What do you see?