sql对日期的操作

想把  2010-2-3 下午 04:57:47 变成 02/03
能不能实现!

---

SQL code:
declre @s datetime
set @s='2010-02-03'
select '0'+ltrim(month(@s))+'/'+'0'ltrim(day(@s))

---

SQL code:
select left(convert(char(11),getdate(),101),5), right(convert(char(11),getdate(),111),5)

---

SQL code:
select convert(varchar(5),convert(datetime , replace('2010-2-3 下午 04:57:47','下午','')),103)
/*

-----
03/02

(1 行受影响)

*/

---

SQL code:
declare @s varchar(100)
set @s='2010-2-3 下午 04:57:47'
select '0'+substring(@s,6,1)+'/'+'0'+substring(@s,8,1)
/*

-------
02/03

(1 行受影响)

---

SQL code:
declare @a varchar(50)
SET @a='2010-2-3 下午 04:57:47'
SELECT convert(varchar(5),cast(replace(@a,'下午','') as datetime),101)

--result
/*-----
02/03

（所影响的行数为 1 行）
*/

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (f