[email protected] wrote on 2014-08-18: > select CAST('02' as Integer); > > Works in MariaDB 5.5.33a. Does NOT work in MySQL 5.5.37. Here's the > error message: http://screencast.com/t/cgAlQR7e > > Ideas? > > (The real SQL is extracting the first 2 characters of a HHMM time > string; I'm trying to get the hours and minutes values. MySQL doesn't > have a VAL() function.) > > tia, > --Mike
Mike, Does MySQL required Integer to be lowercase or just int? Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
