•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 427,809 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,853 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 27131 | 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: 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().
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
create table tblname (
fieldname datetime default getdate()
)
fieldname datetime default getdate()
)
•
•
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 3:10 pm. Reason: solution
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 2 (0 members and 2 guests)
Linear Mode
- Newbie in need of help!!! (C++)
- Inserting datas from two tables to third table with a command. is it possible (MySQL)
- Field default value (PHP)
- How to display column descriptions? (Database Design)
Other Threads in the MS SQL Forum
- Previous Thread: SQL DB Connection Problems
- Next Thread: how to store video files
