Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Yats
Starting Member
1 Post |
 Posted - 2002-08-06 : 12:08:02
|
| Hello ,How do i add a timestamp column to the existing table ? I want to have some reference to the dates to check that my text file import into the database occurs everyday successfully . Thanks for your help . |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-06 : 12:17:33
|
| Just to clarify, in SQL Server a timestamp data/column type is NOT a date/time value, as defined in the SQL standard. You'd want to add a datetime column, the following should do:ALTER TABLE myTable ADD LoadDate datetime DEFAULT (getdate())This adds a column called "LoadDate" and sets a default value of the current date and time. See Books Online for more information. |
 |
|
|
|
|
|
Adding Timestamp Columns