DateFormat

[mary mathews]

I want to convert a date(which is in the DDMMYYYY format) into the MMDDYYYY format in sql query.below is my query but its not working??
Do anyone have any idea???

declare @s char(10)
set @s = '21/04/2008'
select convert(char(10),@s,101)

[deepuv04]

I want to convert a date(which is in the DDMMYYYY format) into the MMDDYYYY format in sql query.below is my query but its not working??
Do anyone have any idea???

declare @s char(10)
set @s = '21/04/2008'
select convert(char(10),@s,101)

Hi,
Try declaring @s as datetime and set the value as '2008-04-21'

then your query will execute currectly

declare @s DATETIME 
--set @s = '21/04/2008'
set @s = '2008-04-21'
select convert(char(10),@s,101)
 
 

[ck9663]

I want to convert a date(which is in the DDMMYYYY format) into the MMDDYYYY format in sql query.below is my query but its not working??
Do anyone have any idea???

declare @s char(10)
set @s = '21/04/2008'
select convert(char(10),@s,101)

Try:

declare @s varchar(10)
 
set @s = '21/04/2008'
 
select convert(varchar(20), convert(datetime, @s, 103),101)

-- CK