On Mon, Apr 16, 2001 at 07:54:56AM -0500, Jeff Holzfaster wrote:
>
> Hi!
>
> This query works: select date_format(date, "%W, %e %M %Y") as date from
> table
> This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
> ",another) as time_of_day
>
> I'm wondering if it is possible to use concat in this way and how if it is
> possible.
Is there a newline between the quotes in the second example, or are those just
spaces, broken to another line by your mailer?
What exactly is 'another' in your second query?
This works for me, even with a newline:
mysql> select concat(date_format(a_mtime, "%W, %e %M %Y"), "
"> ", a_muser) as time_of_day from articles where a_muser='roam';
+------------------------------+
| time_of_day |
+------------------------------+
| Wednesday, 4 April 2001
roam |
| Saturday, 24 March 2001
roam |
| Monday, 26 March 2001
roam |
+------------------------------+
3 rows in set (0.05 sec)
G'luck,
Peter
--
I've heard that this sentence is a rumor.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
