Please support our MS SQL advertiser: Programming Forums
Views: 29920 | Replies: 5
 |
•
•
•
•
| |
•
•
Join Date: Jul 2005
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Aug 2005
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
In the column definition: default value = now()
•
•
Join Date: Jul 2005
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanks will try it
•
•
Join Date: Dec 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Default current datetime for column •
•
•
•
Originally Posted by weilander 
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.
Last edited by wieland : Dec 26th, 2006 at 4:10 pm. Reason: solution
•
•
Join Date: May 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by 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
It doesn't work for me. I have an error message when trying to use now().
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode