How to convert string to datetime in SQL
By FoxLearn 11/16/2024 4:34:16 AM 106
To convert a string to a DATETIME type in SQL, you can use the CAST() or CONVERT() functions.
How to use CAST() to convert String to DateTime in SQL?
The CAST()
function is a standard SQL method for converting one data type to another.
SELECT CAST('2025-10-16 11:30:00' AS DATETIME)--2025-10-16 11:30:00.000
How to use CONVERT() to convert String to DateTime in SQL?
In SQL, you can use the CONVERT()
function to convert a string to a DATETIME
type. The syntax for CONVERT()
is:
CONVERT(data_type, expression, style)
For example:
SELECT CONVERT(DATETIME, '2025-10-16 11:30:00', 120)--2025-10-16 11:30:00.000
Here, 120
is the style for the YYYY-MM-DD HH:MI:SS
format, which is commonly used for DATETIME
values.
If your string is in a different format, you can adjust the style.
For example, if the string is in the format 'MM/DD/YYYY HH:MI:SS'
, you can use style 101
:
SELECT CONVERT(DATETIME, '11/26/2025 11:30:00', 101)--2025-11-26 11:30:00.000
- How to fix 'The specified sa password does not meet strong password requirements'
- How to Set Up Dark Theme in SQL Server Management Studio
- DBCC CHECKIDENT RESEED 0
- How to drop temporary table if exists
- How to convert timestamp to date in SQL Server
- How to convert SQL Server's timestamp column to datetime format
- How to convert varchar to uniqueidentifier in SQL Server
- How to Read Excel file and Import data from Excel to SQL Server in C#
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
12/19/2024