Conversion of dates in the database

Question

How to convert a date that is in format DDMMYYYY for YYYYMMDD?

I am having problems to send this data to different SQL databases, considering that each one was elaborated in a way and are already fed.

Answer 1

If your database is Mysql you can use a mysql function when doing Insert.

DATE_FORMAT(data, '%Y-%m-%d').

http://www.w3schools.com/sql/func_date_format.asp