Add default value of datetime field in SQL Server to a timestamp

by

For modifying an existing column in an existing table:

ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn

More Related Contents:

  1. Sql Server string to date conversion
  2. How to convert SQL Server’s timestamp column to datetime format
  3. How can I truncate a datetime in SQL Server?
  4. What is the significance of 1/1/1753 in SQL Server?
  5. How to get Time from DateTime format in SQL?
  6. How to get first and last day of previous month (with timestamp) in SQL Server
  7. How to remove the time portion of a datetime value (SQL Server)?
  8. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  9. Date conversion and culture: Difference between DATE and DATETIME
  10. SQL Query to find the last day of the month
  11. Handling date in SQL Server
  12. How can I get the sum of multiple datetime values?
  13. Comparing dates stored as varchar
  14. Best way to store time (hh:mm) in a database
  15. Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()
  16. SQL Server Group by Count of DateTime Per Hour?
  17. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  18. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  19. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  20. Convert UTC Milliseconds to DATETIME in SQL server
  21. How does SQL Server decide format for implicit datetime conversion?
  22. Undesired rounding of DateTime in SQL Server
  23. How to convert text column to datetime in SQL
  24. How to calculate difference in hours (decimal) between two dates in SQL Server?
  25. Subquery in select not working in SQL Server
  26. Dynamic SQL (passing table name as parameter)
  27. SQL Server convert string to datetime
  28. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  29. Dynamically assign filename to excel connection string
  30. T-SQL query to show table definition?

Leave a Comment