A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



How do I get the user to enter a dtae in DD/MM/YYYY format and store it in mySQL 'YYYY/MM/DD' Format
I am new to mysql and I am having problems with the date function. I can store information in the tables using the mySQL format however I need to ask the users to enter their date of births in the DD/MM/YYYY format then reverse it and store it in the database. How can I change the date format prior to entering in the data into the tables. Thanks Mark
db2 variations:
None

access
db2
mysql
oracle
postgres
sqlserver