How to convert sql string datetime

Question

How do I convert/cast the string April 04, 2016 12:00:00 to DATETIME in sql server 2005?

UPDATE I would like to compare dates like this :

SELECT * 
from ZeroAndLackingRequest  
WHERE request_date BETWEEN CONVERT(DATETIME,'April 04, 2016 12:00:00',103)  
                   AND CONVERT(DATETIME,'April 04, 2016 11:59:59',103)

but it is not working. Any Ideas why?

SELECT cast('April 04, 2016 12:00:00' AS datetime)

Abdul Rasheed
– Abdul Rasheed

2016-04-04 06:56:44 +00:00
Commented Apr 4, 2016 at 6:56 — Abdul Rasheed
– Abdul Rasheed, Commented Apr 4, 2016 at 6:56
I have updated my question, kindly check it

JanLeeYu
– JanLeeYu

2016-04-04 07:01:58 +00:00
Commented Apr 4, 2016 at 7:01 — JanLeeYu
– JanLeeYu, Commented Apr 4, 2016 at 7:01

Abdul Rasheed · Accepted Answer · 2016-04-04 06:58:33Z

1

SELECT cast('April 04, 2016 12:00:00' AS datetime)

OR

SELECT CONVERT(DATETIME,'April 04, 2016 12:00:00')

For more details

answered Apr 4, 2016 at 6:58

Abdul Rasheed

6,7794 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abdul Rasheed Over a year ago

Plz check the date you entered in where clause, the lowest date should be first (change to eg:- SELECT * from ZeroAndLackingRequest WHERE request_date BETWEEN CONVERT(DATETIME,'April 01, 2016 12:00:00',103) AND CONVERT(DATETIME,'April 05, 2016 11:59:59',103))

Abdul Rasheed Over a year ago

if you don't need to check the time, them you can COVERT to DATE instead of DATETIME

Rajarshi Das · Accepted Answer · 2016-04-04 08:25:10Z

0

Select * from [ZeroAndLackingRequest] Z where Z.request_date =  CONVERT(datetime, 'April 04, 2016 12:00:00', 120)

remember I choose 120 style you can chooose 103 or any other please see below link.

For a full discussion of CAST and CONVERT, including the different date formatting options, see the MSDN Library Link below:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

If you want to compare

Select * from [ZeroAndLackingRequest] Z  
where cast(Z.request_date as datetime) >= cast('April 04, 2016 12:00:00' as datetime) 
and cast(Z.request_date as datetime) < cast('April 04, 2016 11:59:59' as datetime)

edited Apr 4, 2016 at 8:25

answered Apr 4, 2016 at 6:59

Rajarshi Das

12.4k7 gold badges53 silver badges88 bronze badges

Collectives™ on Stack Overflow

How to convert sql string datetime

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related