how to convert string into datetime

Question

Declare @date_and_time varchar(100)= '04/29/23 01:29:55'

Sachin Singh · Answer

also like this Declare @date_and_time varchar(100)= '04/29/23 01:29:55' select Cast(@date_and_time as datetime)

Tuhin Paul · Answer

string date_and_time = "04/29/23 01:29:55"; DateTime datetime; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("SELECT CONVERT(datetime, @date_and_time, 101)", connection)) { command.Parameters.AddWithValue("@date_and_time", date_and_time); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { datetime = reader.GetDateTime(0); } } } }

Rajkiran Swain · Answer

You can use the `CONVERT` function in SQL Server to convert the string to a datetime data type. Here's an example: ``` DECLARE @date_and_time varchar(100) = '04/29/23 01:29:55' DECLARE @datetime datetime SET @datetime = CONVERT(datetime, @date_and_time, 101) SELECT @datetime ``` In this example, the third parameter of the `CONVERT` function, which is set to 101, specifies the style of the input date string. Style 101 represents the format `mm/dd/yyyy`. The converted datetime value can then be assigned to a datetime variable or used in a query.

Raj Bhatt · Answer

you can try below code :- SELECT CONVERT(datetime, '2023-05-07 12:34:56', 120) As Todaydate SELECT CAST('2023-05-07 12:34:56' AS datetime) As Todaydate

Anandu G Nath · Answer

Declare @date_and_time varchar(100); set @date_and_time= '04/29/23 01:29:55' select Cast(@date_and_time as datetime) print Cast(@date_and_time as datetime)

how to convert string into datetime

Answers (5)