Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Add Dates

Status
Not open for further replies.
baden100

baden100

Programmer
Joined
Apr 26, 2006
Messages
10
Location
US

When I've got a DateTime field defined in a SQL Server table, how do I get the value to get auto populated if none is given in a query.

ie. If I manually add a record to the table, I want the datetime field to autopopulate.


Thanks
 
Sort by date Sort by votes
use GetDate() function to insert the current date...

-DNG
 
Upvote 0 Downvote
You can set a default on the date column to getdate()

Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
How to add a Letter to datepart
Replies
5
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
barim
  • Locked
  • Question Question
Compare Dates With Current Date
Replies
3
Views
359
barim
barim
WomanPro
  • Locked
  • Question Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
813
Chris Miller
Chris Miller
kingz2000
  • Locked
  • Question Question
select data with date condition, choosing latest values from selected dates
Replies
16
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top