Convert varchar dd mm yyyy to dd mm yyyy datetime

Question

I m trying to convert a date in a varchar column in the dd mm yyyy format into the datetime dd mm yyyy format  so then I can run date range queries on the data   So far I have the following which is not working  CONVERT varchar  CAST date started AS datetime   103    I have also tried  convert date started as datetime  103    I need to make sure the output is as dd mm yyyy as we re in the UK and not the mm dd yyyy format

User · Answer

You can do like this   SELECT convert datetime  convert date   27-09-2013   103   103

User · Answer

I think you are after this   CONVERT datetime  date as string  103    Notice  that datetime hasn t any format  You think about its presentation  To get the data of datetime in an appropriate format you can use  CONVERT varchar  date as datetime  103

User · Answer

I think that more accurate is this syntax   SELECT CONVERT CHAR 10   GETDATE    103    I add SELECT and GETDATE   for instant testing purposes

User · Answer

If you want to return a format mm dd yyyy  then use 101 instead of 103  CONVERT VARCHAR 10    MyDate   101

User · Answer

Try this code   CONVERT varchar 15   date started  103

[sql-server] Convert varchar dd/mm/yyyy to dd/mm/yyyy datetime

Examples related to sql-server

Examples related to sql-server-2008

Examples related to tsql

Examples related to date

Examples related to datetime