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

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

[/code]

[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