How to append string to table column name in SQL

Question

0.00/5 (No votes)

See more:

Hello,

I want to concatenate the date to the column name while selecting the data from a table.

E.g.:

SQL

SELECT field1 as newfieldname --for changing the field1 to newfieldname
FROM tablename

I want a new field name with current datetime, so it should be like this newfieldname_10/08/2013. How can we append a datetime to the column name in a SQL select statement?

Thanks,

Ginnas

Posted 9-Oct-13 4:25am

ginnas

Updated 9-Oct-13 4:35am

Manfred Rudolf Bihy

v2

Add a Solution

Comments

RedDk 9-Oct-13 15:50pm

Not GetDate() concatenation because the "date" of which you speak is more of a date in the data somewhere? If not, then Solution 01 top's your answer.

Are tables currently named as "dates" by any chance?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-10-09T04:32:00

Solution 1

If you mean you want the string "fieldname" then do this.

SQL

SELECT 'fieldname_' + CONVERT(NVARCHAR (50), GetDate())

If you actually mean you want the value out of that field name then do

SQL

SELECT fieldName + CONVERT(NVARCHAR (50), GetDate())
FROM table1 ...

Posted 9-Oct-13 4:32am

ZurdoDev

Comments

Manfred Rudolf Bihy 9-Oct-13 10:39am

OP wants to change the column name as in his example, but he wants to append the current date. I don't think you can only do that by constructing the SQL statement and then execute it. The part after "as" can only be an identifier, I think.

Cheers!

ZurdoDev 9-Oct-13 10:46am

In that case the OP will need to use EXEC @sql and build it all dynamically. However, the requirement does not make sense.

Manfred Rudolf Bihy 9-Oct-13 11:04am

I don't understand it either, why somebody would want to do that. :)

Cheers!