How to concat values which retrieved from database

Question

I am executing this query in SQL Server 2008

 SELECT (CONVERT(DATE, GETDATE()))

and it shows the result 2013-07-22.

I need to print this result as 22713, where 22 is the date 7 is the month 13 is the year.

How could I do this?

Displayed how? Desktop, browser, tablet, phone, language....? — duffymo, Jul 22 '13 at 11:43
Operations with string isn't what SQL is best at. More good practice use other tools (Java, Python, C#, etc) — Michael Kazarian, Jul 22 '13 at 11:46
till now I didn't do nothing, i do not have such any idea how to do this — sidhewsar, Jul 22 '13 at 11:47
It's a rendering issue. Let the technology that's doing display format it appropriately. Get it from the database as a Date. — duffymo, Jul 22 '13 at 11:54

score 1 · Accepted Answer · answered Jul 22 '13 at 11:52

1

SELECT CAST(DATEPART(dd,GETDATE()) as varchar(10))
  +CAST(DATEPART(mm,GETDATE()) as varchar(10))
  +RIGHT(CAST(DATEPART(YY,GETDATE()) as varchar(10)),2)

SQLFiddle demo

answered Jul 22 '13 at 11:52

valex

23,966
7
43
60

Michael Kazarian · Answer 2 · 2013-07-22T12:14:25.267

1

1) It bad practice use SQL for string operation. More right external tools 2) I use other RDBMS. Below query work with it:

select (extract(day from ua.stamp))||(extract(month from
ua.stamp))||(extract(year from ua.stamp)) from useractions ua

Furthemote, this link can help you: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/55d23bb0-6e1e-4a03-9bed-94e7c755ec4d/get-the-day-from-date-value-in-sql-server

edited Jul 22 '13 at 12:14

answered Jul 22 '13 at 12:03

Michael Kazarian

4,376
1
21
25

score 0 · Answer 3 · answered Jul 22 '13 at 11:42

0

You could read the string, go over it with a tokenizer, split it and put it back together the way you want it to be. What language are you using?

answered Jul 22 '13 at 11:42

AnyOneElse

406
2
6
17

How to concat values which retrieved from database

3 Answers3