SQL Server Convert Varchar to Datetime

Question

I have this date format  2011-09-28 18 01 00  in varchar   and I want to convert it to datetime changing to this format 28-09-2011 18 01 00  How can I do it

User · Answer

You could do it this way but it leaves it as a varchar

declare @s varchar(50)

set @s = '2011-09-28 18:01:00'

select convert(varchar, cast(@s as datetime), 105) + RIGHT(@s, 9)

or

select convert(varchar(20), @s, 105)

User · Answer

As has been said  datetime has no format string representational format   You can change the string output with some formatting   To convert your string to a datetime   declare  date nvarchar 25   set  date    2011-09-28 18 01 00    -- To datetime datatype SELECT CONVERT datetime   date    Gives   ----------------------- 2011-09-28 18 01 00 000   1 row s  affected    To convert that to the string you want   -- To VARCHAR of your desired format SELECT CONVERT VARCHAR 10   CONVERT datetime   date   105        CONVERT VARCHAR 8   CONVERT datetime   date   108    Gives   ------------------- 28-09-2011 18 01 00   1 row s  affected

User · Answer

Try the below   select Convert Varchar 50  yourcolumn 103  as Converted Date from yourtbl

User · Answer

SELECT CONVERT VARCHAR 10   GETDATE    105          CONVERT VARCHAR 10   GETDATE    108

User · Answer

Like this  DECLARE  date DATETIME SET  date    2011-09-28 18 01 00  select convert varchar   date 105          convert varchar   date 108

User · Answer

You can have all the different styles to datetime conversion   https   www w3schools com sql func sqlserver convert asp This has range of values  - CONVERT data type length  expression style   For style values  Choose anyone you need like I needed 106

User · Answer

SELECT CONVERT Datetime   2011-09-28 18 01 00   120  -- to convert it to Datetime  SELECT CONVERT  VARCHAR 30    date  105  -- italian format  28-09-2011 18 01 00          SELECT CONVERT  VARCHAR 30    date  108   -- full date  with time minutes sec

User · Answer

this website shows several formatting options   Example   SELECT CONVERT VARCHAR 10   GETDATE    105

[sql] SQL Server Convert Varchar to Datetime

Examples related to sql

Examples related to sql-server

Examples related to datetime

Examples related to formatting

Examples related to varchar