i want to convert 30/07/2013 date into datetime format
How to convert string date into datetime fromat
How to convert string date into datetime fromat
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sanjeeb LenkaPosted Jul 30, 2013, 2:53 AM
SELECT convert(datetime, '30/07/2013', 103)
if date is in mm/dd/yyyy format
select CONVERT(date,'07/30/2013',101)
if date is in yyyy/mm/dd
SELECT convert(datetime, '2013/07/30', 120)
Iftikar HussainPosted Jul 30, 2013, 2:39 AM
Try like this
select CONVERT(datetime,'30/07/2013',103)
Regards,
Iftikar