Hi!
I have to transform german date form inputs (dd.mm.yyyy) to the mySQL database format (yyyy-mm-dd). How can I do this? I have no problems transforming the database output into the german format. My problem is the other direction: user enters dd.mm.yyyy inputs and I want to store yyyy-mm-dd in the database.
I tried to write a plugin that does the transformation but can't get it work.
BTW. In the manual p. 28 I read as explanation for the date type of table colums
But where are these "Date Options"? I can't find them.
I found an admin template (setup_date.html) which looks very promising but the template seems not to be used in my DBMan SQL installation.
Thank you!
Armin
I have to transform german date form inputs (dd.mm.yyyy) to the mySQL database format (yyyy-mm-dd). How can I do this? I have no problems transforming the database output into the german format. My problem is the other direction: user enters dd.mm.yyyy inputs and I want to store yyyy-mm-dd in the database.
I tried to write a plugin that does the transformation but can't get it work.
BTW. In the manual p. 28 I read as explanation for the date type of table colums
Quote:
A data column contains a date that complies with the "Date Options" in the Setup menu.But where are these "Date Options"? I can't find them.
I found an admin template (setup_date.html) which looks very promising but the template seems not to be used in my DBMan SQL installation.
Thank you!
Armin