Is it possible to format date without leading zeros?

Question

Using CONVERT with style 101 causes date to look like "04/07/1010"

Is there a way to make it look like "4/7/1010"?

Answer 1

declare @dt datetime
set @dt='04/07/2010'

select replace(left(convert(varchar, @dt, 101),5), '0', '')+right(convert(varchar,@dt,101), 5)

---

http://www.t-sql.ru

Answer 2

declare
 @dt datetime

set
 @dt='04/07/2010'


select
 replace
(left
(convert
(varchar
, @dt, 101),5), '0'
, ''
)+right
(convert
(varchar
,@dt,101), 5)

---

http://www.t-sql.ru

Yeah, this will work but I hoped there is some style I missed

Answer 3

Sorry,

 

declare @dt datetime
set @dt='04/20/2010'

select replace(left(convert(varchar, @dt, 101),2), '0', '')+
replace(right(convert(varchar,@dt,101), 8),'/0','/')

---

http://www.t-sql.ru

Answer 4

You could also do this:

DECLARE @dt datetime
SET @dt='20100407'
SELECT LTRIM(STR(MONTH(@dt)))+'/'+LTRIM(STR(DAY(@dt)))+'/'+STR(YEAR(@dt),4)

 

---

--Brad (My Blog)

Answer 5

I think replace would not work here. You may want to use Brad's suggestion instead.

---

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog

Answer 6

SELECT ltrim(MONTH(@dt))+'/'+ltrim(day(@dt))+'/'+ltrim(year(@dt))

Answer 7

Obviously this is an old question, but you can also do the following:

convert(varchar,DATEPART(MM, GETDATE()))+'/'+convert(varchar,DATEPART(DD, getdate()))+'/'+convert(varchar,DATEPART(YYYY, GETDATE()))

replace

getDate()

with your date field. This will yield the date in a varChar() string without the leading zeroes.