At 12:39 -0400 9/20/02, Stanley, Jason wrote: >hello all, > >i have the following selection in my query... >DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME > >now, i want to apply LCASE or LOWER to it, but i'm a little unsure >how to handle the syntax with two sets of parentheses.
The alias follows the entire expression, so it would be done like this: LCASE(DATE_FORMAT(....)) as TIME >any insight? > >tia, >j --------------------------------------------------------------------- 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