Page 1 of 1
Post Changed Date
Posted: Tue Sep 01, 2009 11:43 pm
by raggy99
What I am wanting to do is on the website input the date as (Date/Month/Year) however i need to convert this to (Year/Month/Day) for mysql when i record it.
ATM when i put input on the website 25/12/2009 in the database it shows 0000-00-00
your help would be greatly appreciated.
Re: Post Changed Date
Posted: Tue Sep 01, 2009 11:50 pm
by requinix
So
split the string on the slashes and reassemble them as you want.
It'd actually be better if you got the month, day, and year separately. Then there's no chance of month/day confusion.
Re: Post Changed Date
Posted: Wed Sep 02, 2009 12:00 am
by raggy99
tasairis wrote:So
split the string on the slashes and reassemble them as you want.
It'd actually be better if you got the month, day, and year separately. Then there's no chance of month/day confusion.
I should of said that i'm doing this in dreamweaver and I am a total noob.
could you post come date code and then i might be able to get my head around it?
thx