Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()

by

CURRENT_TIMESTAMP is standard ANSI SQL, and so is theoretically one tiny little island of ‘don’t need to change’ amongst your thousands of SQL Server-specific lines of SQL if you ever need to move databases….

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. Add default value of datetime field in SQL Server to a timestamp
  15. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  16. Best way to store time (hh:mm) in a database
  17. SQL Server Group by Count of DateTime Per Hour?
  18. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  19. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  20. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  21. Convert UTC Milliseconds to DATETIME in SQL server
  22. How does SQL Server decide format for implicit datetime conversion?
  23. Undesired rounding of DateTime in SQL Server
  24. How to convert text column to datetime in SQL
  25. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  26. How to calculate difference in hours (decimal) between two dates in SQL Server?
  27. incorrect syntax near keyword where [closed]
  28. Query times out when executed from web, but super-fast when executed from SSMS
  29. Adding a query hint when calling Table-Valued Function
  30. How to display two digits after decimal point in SQL Server

Leave a Comment