How to convert timestamp to date in SQL Server
By FoxLearn 1/9/2025 8:59:09 AM 513
In SQL Server, you can convert a timestamp (or datetime) to just a date using the CAST or CONVERT functions.
How to convert timestamp to date in sql server?
The CAST
function is straightforward and is the most common way to convert a timestamp (datetime) to a date:
For example, sql query to convert timestamp to date
SELECT GETDATE() // 2024-12-09 21:28:06.843 SELECT CAST(GETDATE() AS DATE) // 2024-12-09
The CONVERT
function also works well to convert a timestamp to a date:
SELECT CONVERT(DATE, GETDATE()) // 2024-12-09
The GETDATE() function returns the current date and time in SQL Server.
The CAST(... AS DATE) function converts the timestamp value to only the date (removing the time).
The CONVERT(DATE, ...) is similar to CAST, but you can customize its style if needed.
How to convert timestamp to datetime in SQL?
For example, you need to convert "2024-04-29T07:20:32.727Z" to "2024-04-29 07:20:32".
You can use cast()
// sql server convert timestamp to date select cast('2024-04-29T07:20:32.727Z' as datetime)
Output:
2024-04-29 07:20:32.727
- How to Download and Restore Northwind database to SQL Server
- How to set time to 00:00:00 with GETDATE() in SQL
- Restoring MySQL Databases with mysqldump
- How to use Oracle linked server shows all tables
- Download backup of Northwind database for SQL Server
- How to Convert varchar to uniqueidentifier in SQL Server
- How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
- How to use ROW_NUMBER Function in SQL Server