How to convert timestamp to date in SQL Server

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