List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 20 2002 4:58pm
Subject:Re: String Functions and Date Format Living Together in Harmony?
View as plain text  
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

Thread
String Functions and Date Format Living Together in Harmony?Jason Stanley20 Sep
Re: String Functions and Date Format Living Together in Harmony?Paul DuBois20 Sep