Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-26 Thread Dan Ragle
Great information, thanks again. Dan On 9/23/2015 11:01 PM, Alexander Barkov wrote: Hi Dan, On 09/24/2015 12:35 AM, Dan Ragle wrote: On 9/22/2015 5:12 PM, Alexander Barkov wrote: On 09/23/2015 01:00 AM, Alexander Barkov wrote: Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We&#x

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-23 Thread Dan Ragle
On 9/22/2015 5:12 PM, Alexander Barkov wrote: On 09/23/2015 01:00 AM, Alexander Barkov wrote: Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the followi

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Dan Ragle
gument, which is a date literal, but substr returns string, which must be cast internally. --Justin Sent from my iPhone On Sep 19, 2015, at 3:53 PM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's goin

[Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-19 Thread Dan Ragle
atloads of code that I would have to scan through to try and find these differences. 3.) If there is no way to revert to the 5.1 behavior, can someone help me to understand the exact reason why the milliseconds get displayed on the final select in MariaDB 5.5? I'll need to lo