Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How to transform date input?

Quote Reply
How to transform date input?
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

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
Subject Author Views Date
Thread How to transform date input? Armin 4038 Dec 5, 2002, 5:18 AM
Thread Re: [Armin] How to transform date input?
Inertia 3967 Dec 5, 2002, 12:18 PM
Thread Re: [Inertia] How to transform date input?
Armin 3942 Dec 5, 2002, 1:58 PM
Thread Re: [Armin] How to transform date input?
jean 3941 Dec 5, 2002, 3:28 PM
Post Re: [jean] How to transform date input?
Armin 3935 Dec 6, 2002, 12:16 AM
Thread Re: [jean] How to transform date input?
olivers 3605 Jun 1, 2004, 2:16 AM
Thread Re: [olivers] How to transform date input?
olivers 3596 Jun 1, 2004, 2:59 AM
Thread Re: [olivers] How to transform date input?
olivers 3551 Jun 20, 2004, 12:10 PM
Post Re: [olivers] How to transform date input?
olivers 3542 Jun 21, 2004, 8:39 AM