MySQL Forums :: General :: UPPER with substring is not working


Advanced Search

UPPER with substring is not working
Posted by: venkata dumpala ()
Date: March 04, 2009 08:53PM

Guys ,
i am trying to convert Saturday to SAT by using following code.
SELECT UPPER(SUBSTRING(DAYNAME('2007-02-03'),1,3) );
It is returning as 'Sat' instead of 'SAT'
Why the UPPER function is failing ?

Thanks
Venkat

Options: ReplyQuote


Subject Written By Posted
UPPER with substring is not working venkata dumpala 03/04/2009 08:53PM
Re: UPPER with substring is not working Peter Brawley 03/05/2009 02:49AM
Re: UPPER with substring is not working venky babs 03/05/2009 10:16AM
Re: UPPER with substring is not working venkat Java 03/05/2009 05:33PM
Re: UPPER with substring is not working venkat Java 03/07/2009 10:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.