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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date option
- Thread starter canrizwan
- Start date
I assume you are doing this through Enterprise Manager?
If so, you simply add another column, and set its' data type to date/time. If you want it to include TODAY's date, you can set the default to CURRENT_TIMESTAMP or GETDATE(), either of which will return the server's current date/time. (storing the time the row was added, this column will not change).
Hope this helps,
ALex
ps- for future reference, you may be better off asking questions like this in forum183 or forum962
Ignorance of certain subjects is a great part of wisdom
If so, you simply add another column, and set its' data type to date/time. If you want it to include TODAY's date, you can set the default to CURRENT_TIMESTAMP or GETDATE(), either of which will return the server's current date/time. (storing the time the row was added, this column will not change).
Hope this helps,
ALex
ps- for future reference, you may be better off asking questions like this in forum183 or forum962
Ignorance of certain subjects is a great part of wisdom
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question