How to convert timestamp to date in SQL Server
By FoxLearn 1/9/2025 8:59:09 AM 609
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 find all the dependencies of a table in SQL Server
- How to Find Objects Referencing a Table in SQL Server
- Case sensitivity in SQL Server
- How to Convert varchar to uniqueidentifier in SQL Server
- How to use GROUP BY in SQL
- Filtering GROUP BY with HAVING and WHERE in SQL
- Using GROUP BY with ORDER BY in SQL
- Aggregate functions with GROUP BY in SQL
Categories
Popular Posts
How to secure ASP.NET Core with NWebSec
11/07/2024
Freedash bootstrap lite
11/13/2024
Admin BSB Free Bootstrap Admin Dashboard
11/14/2024