"Matt Tucker" <[EMAIL PROTECTED]> wrote:
> I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat
> on Red
> Hat Linux with mySQL. Of course, there's about a hundred queries that use dates and
> of
> course, they're all in the format mm-dd-yyyy. is there a way to format the date
> column in
> my mysql tables to accept a date in this format or do i really have to go through
> every
> sql statement and parse the date and rebuild it to be yyyy-mm-dd? thanks so much.
If you want to store values in the DATE columns you shoul convert all data to the
yyyy-mm-dd format. Then you can use DATE_FORMAT() function to retrieve data in various
formats:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
