Hi Giorgio, Works for me mysql 4.0.22 on Solaris 9.
localhost.(none)>SELECT UPPER(DAYNAME(NOW())); +-----------------------+ | UPPER(DAYNAME(NOW())) | +-----------------------+ | THURSDAY | +-----------------------+ 1 row in set (0.04 sec) localhost.(none)>SELECT LOWER(DAYNAME(NOW())); +-----------------------+ | LOWER(DAYNAME(NOW())) | +-----------------------+ | thursday | +-----------------------+ 1 row in set (0.00 sec) localhost.(none)>\s -------------- mysql Ver 12.22 Distrib 4.0.22, for sun-solaris2.9 (sparc) Connection id: 78 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.22-standard Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 13 days 15 hours 48 min 18 sec What version are you running? and what platform? Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Frondoni, Giorgio [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 October 2005 10:30 AM To: mysql@lists.mysql.com Subject: UPPER/LOWER and DAYNAME Why the UPPER and LOWER functions don't have any effect in the following statements? SELECT UPPER(DAYNAME(NOW())); SELECT LOWER(DAYNAME(NOW())); While other String related functions such as LENGTH produce the expected result? If you know, please let me know. Thank you Giorgio Frondoni AVP, Chief of System Development TransCore phone: (858) 826-4750 cell: (760) 214-4092 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
