Date format with zeros

Question

With this:

, CAST(DATEPART(Yy,DATEADD(Month,1,GETDATE())) as varchar(4)) + '-' + 
CAST(DATEPART(Mm,DATEADD(Month,1,GETDATE())) as varchar(2)) + '-' +
CAST(DATEPART(Dd,DATEADD(Month,1,GETDATE())) AS varchar(2)) AS expiration_date

I get this: 2013-9-2

What I need is 2013-09-02

Need to have the 0 before single digit dates. What needs to be changed?

Thank you

What's wrong with `CONVERT(varchar(10),DATEADD(month,1,GETDATE()),120)`? (Aside from the fact that you're treating dates as strings at all, which should generally be avoided) — Damien_The_Unbeliever, Aug 02 '13 at 13:35
That worked perfect. How to get the date one day less? Current output 2013-09-02, need 2013-09-01 — user2646056, Aug 02 '13 at 13:52

Ocaso Protal · Answer 1 · 2013-08-05T05:26:38.390

0

If this is SQL Server, use CONVERT:

 SELECT CONVERT(varchar(10), DATEADD(Month,1,GETDATE()), 120)

If you need the day before that date, just use DATEADD again:

SELECT CONVERT(varchar(10), DATEADD(Day, -1, DATEADD(Month,1,GETDATE())), 120)

edited Aug 05 '13 at 05:26

answered Aug 02 '13 at 13:36

Ocaso Protal

19,362
8
76
83

How to get the date one day less? Current output 2013-09-02, need 2013-09-01 – user2646056 Aug 02 '13 at 14:04

Date format with zeros

1 Answers1