0

Hi,

How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table

I'm using Enterprise Manager in MSSQL

Many Thanks

6
Contributors
7
Replies
13
Views
12 Years
Discussion Span
Last Post by AliQadir
0

Hi,

How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table

I'm using Enterprise Manager in MSSQL

Many Thanks

It doesn't work for me. I have an error message when trying to use now().

0

In the column definition: default value = now()

Err: user must input default value to = ( getdate() )

With this SQL will insert the date + time everytime someone inserts values in that columns.

0

Hi,
I have created two columns in the DB and I want to insert fill these two columns with current datetime.How Can I do It,Please reply

CheckInTime datetime,
CheckOutTime datetime
insert CheckTime values(1,'','',and what should I do for the datetime)
Thank you.
Regards.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.