Re: String Functions and Date Format Living Together in Harmony?

[Paul DuBois]

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