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