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.
-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
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()