As Mark said, it's hard to believe mySQL is doing this. The other element is Sequel Pro - not likely but maybe it's doing the time conversion?
Have you tried selecting the data with Livecode (revDataFromQuery)? On Wed, Mar 25, 2015, 7:18 AM Paul Foraker <p...@whitefeather.com> wrote: > Thanks, Mark. > > On Wed, Mar 25, 2015 at 1:27 AM, Mark Schonewille < > m.schonewi...@economy-x-talk.com> wrote: > > > Can you confirm that the MySQL syntax you see in the message box is the > > same as what you entered in Sequel Pro? > > > > In Sequel Pro, I wrapped the time period in double quotes. > > When we tried that in LiveCode, it posted the quotes to the field, and the > times were still adjusted. > > (I mistyped the 10... it's set at 20). > > > > > > What are the collations of the database and the time field? > > > > Sequel Pro is displaying 'latin1_swedish_ci' as the default for the VARCHAR > fields. > > -- > > White Feather Software > www.whitefeather.com > Cell: 408-391-1480 > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
