Using PHP and MySQL I can SELECT a date field and it returns YYYY-MM-DD, or SELECT a date/time field and it returns YYYY-MM-DD HH:MM:SS. Great, just what I want...
BUT - using MyODBC, it returns DD/MM/YY for a date (or date/time with a zero time part) or DD/MM/YY HH:MM:SS for a date/time.
Really, I'd like the program that's talking to MySQL via ODBC to have the same kind of result that I'd get with PHP.
It's late, I'm tired, and I'm guessing I could probably muck around with my SELECT, using concat() to get a text field result rather than a date/time which would probably solve my problem? But it's not ideal...
Thanks in advance
Paul
BUT - using MyODBC, it returns DD/MM/YY for a date (or date/time with a zero time part) or DD/MM/YY HH:MM:SS for a date/time.
Really, I'd like the program that's talking to MySQL via ODBC to have the same kind of result that I'd get with PHP.
It's late, I'm tired, and I'm guessing I could probably muck around with my SELECT, using concat() to get a text field result rather than a date/time which would probably solve my problem? But it's not ideal...
Thanks in advance
Paul