RE: UPPER/LOWER and DAYNAME

2005-10-26 Thread Logan, David (SST - Adelaide)
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.

RE: UPPER/LOWER and DAYNAME

2005-10-26 Thread Frondoni, Giorgio
-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(DAY

RE: UPPER/LOWER and DAYNAME

2005-10-26 Thread Logan, David (SST - Adelaide)
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()