How to parametrize additional column title?

[Marek Kotowski]

I need to put current date into additional column title. I mean something like this

SELECT Name_1, ' ' AS CURDATE() FROM Table_1 ...

or, better

SELECT Name_1, ' ' AS CONCAT('My column ', CURDATE()) FROM Table_1 ...

But it doesn't work. AS seems to take only single strings.
Is there any solution?

Thanks in advance.

Marek Kotowski
Warsaw

[Nejoom]

Ma************@ wsip.com.pl (Marek Kotowski) wrote in message news:<e5******* *************** ****@posting.go ogle.com>...

I need to put current date into additional column title. I mean something like this

SELECT Name_1, ' ' AS CURDATE() FROM Table_1 ...

or, better

SELECT Name_1, ' ' AS CONCAT('My column ', CURDATE()) FROM Table_1 ...

But it doesn't work. AS seems to take only single strings.
Is there any solution?

Thanks in advance.

Marek Kotowski
Warsaw

Try (notice the 'AS' keyword is for making an alternative column name):
SELECT Name_1 AS Alternate_name, NOW() FROM Table_1;

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Read for formatting date:
http://www.mysql.com/doc/en/Date_and...functions.html

[Nejoom]

Ma************@ wsip.com.pl (Marek Kotowski) wrote in message news:<e5******* *************** ****@posting.go ogle.com>...

I need to put current date into additional column title. I mean something like this

SELECT Name_1, ' ' AS CURDATE() FROM Table_1 ...

or, better

SELECT Name_1, ' ' AS CONCAT('My column ', CURDATE()) FROM Table_1 ...

But it doesn't work. AS seems to take only single strings.
Is there any solution?

Thanks in advance.

Marek Kotowski
Warsaw

Try (notice the 'AS' keyword is for making an alternative column name):
SELECT Name_1 AS Alternate_name, NOW() FROM Table_1;

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Read for formatting date:
http://www.mysql.com/doc/en/Date_and...functions.html

[Marek Kotowski]

ed**********@ho tmail.com (Nejoom) wrote in message
[...]

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Thank you very much. The problem is I need an empty column
(to be printed and filled later), with a title with a current
date.

MK

[Marek Kotowski]

ed**********@ho tmail.com (Nejoom) wrote in message
[...]

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Thank you very much. The problem is I need an empty column
(to be printed and filled later), with a title with a current
date.

MK

[Nejoom]

Ma************@ wsip.com.pl (Marek Kotowski) wrote in message news:<e5******* *************** ****@posting.go ogle.com>...

I need to put current date into additional column title. I mean something like this

SELECT Name_1, ' ' AS CURDATE() FROM Table_1 ...

or, better

SELECT Name_1, ' ' AS CONCAT('My column ', CURDATE()) FROM Table_1 ...

But it doesn't work. AS seems to take only single strings.
Is there any solution?

Thanks in advance.

Marek Kotowski
Warsaw

Try (notice the 'AS' keyword is for making an alternative column name):
SELECT Name_1 AS Alternate_name, NOW() FROM Table_1;

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Read for formatting date:
http://www.mysql.com/doc/en/Date_and...functions.html

[Marek Kotowski]

ed**********@ho tmail.com (Nejoom) wrote in message
[...]

or for formatting:

SELECT Name_1, DATE_FORMAT(NOW (),'%W, %M %D %Y') AS 'Formated date' FROM Table_1;

Thank you very much. The problem is I need an empty column
(to be printed and filled later), with a title with a current
date.

MK