Hi Giorgio, Looks like a bug in v5. Worked ok in 4.1.3 as well (I just checked)
Yes, time to report it 8-) mysql> SELECT UPPER(DAYNAME(NOW())); +-----------------------+ | UPPER(DAYNAME(NOW())) | +-----------------------+ | Thursday | +-----------------------+ 1 row in set (0.01 sec) mysql> SELECT LOWER(DAYNAME(NOW())); +-----------------------+ | LOWER(DAYNAME(NOW())) | +-----------------------+ | Thursday | +-----------------------+ 1 row in set (0.00 sec) mysql> \s -------------- mysql Ver 12.22 Distrib 4.0.23, for pc-linux (i686) Connection id: 2 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: stdout Using outfile: '' Server version: 5.0.13-rc <--------------------------------------- Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock.v5-13 Uptime: 26 days 23 hours 23 min 34 sec Threads: 1 Questions: 10 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 3 Queries per second avg: 0.000 -------------- mysql> 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:41 AM To: Logan, David (SST - Adelaide); mysql@lists.mysql.com Subject: RE: UPPER/LOWER and DAYNAME David, I have mysql 5.0.15 on Windows. I'm porting an Oracle application to mysql 5.0.x. I guess I have to submit a bug report. Thank you for the quick answer. Giorgio Frondoni AVP, Chief of System Development TransCore San Diego, CA phone: (858) 826-4750 cell: (760) 214-4092 -----Original Message----- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 6:05 PM To: Frondoni, Giorgio; mysql@lists.mysql.com Subject: RE: UPPER/LOWER and DAYNAME 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]