Member Avatar for dieterm

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
  • 367 Views
  • 6 Years Discussion Span
  • Latest Post Latest Post by AliQadir
Member Avatar for weilander

In the column definition: default value = now()

Member Avatar for dieterm

Thanks will try it

Member Avatar for WileECoyote

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().

Member Avatar for campkev

create table tblname (
fieldname datetime default getdate()
)

Member Avatar for wieland

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.

Member Avatar for AliQadir

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.

Member Avatar for AliQadir

I just Passes

GetDate()

and its works Thank You

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.