Re: Concat Question

2001-04-16 Thread Peter Pentchev
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

Re: Concat Question

2001-04-16 Thread Sinisa Milivojevic
Jeff Holzfaster writes: > > 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

Concat Question

2001-04-16 Thread Jeff Holzfaster
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. Thanks! Jeff