3

Using t-sql string functions

substring(convert(varchar, getdate(), 120),6, 11)

this will return mm-dd hh:mm

But then how do I get datetime format yy-mm-dd hh:mm ?

Thank you so much in advance.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Max
  • 229
  • 2
  • 6
  • 18
  • 2
    As an aside, [please don't ever use `varchar` without a length](https://sqlblog.org/blogs/aaron_bertrand/archive/2009/10/09/bad-habits-to-kick-declaring-varchar-without-length.aspx). – Aaron Bertrand Aug 08 '13 at 01:20

1 Answers1

1

Well, convert(varchar(25), getdate(), 120) returns:

          1
1234567890123456789
2013-08-08 01:43:49

So change:

substring(..., 6, 11)

To:

substring(..., 3, 14)

And you'll get:

13-08-08 01:43
Andomar
  • 232,371
  • 49
  • 380
  • 404