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

Quote:

Originally Posted by 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)

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

then your query will execute currectly

Expand|Select|Wrap|Line Numbers

 
declare @s DATETIME 

--set @s = '21/04/2008'

set @s = '2008-04-21'

select convert(char(10),@s,101)

ck9663

Quote:

Originally Posted by 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)

Try:

Expand|Select|Wrap|Line Numbers

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

-- CK

DateFormat

re: DateFormat

re: DateFormat

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about