cgchris99 Posted June 13, 2008 Share Posted June 13, 2008 I have two entry fields for dates. The values are stored as mm/dd/yyyy The mysql fields are setup as DATE. So right now, nothing gets stored in these fields in the DB. I know I need to convert the input field to mysql format but this is where I get lost. I've been looking all over the net trying to figure this out. Even found a couple of functions like input2date() but these don't work or don't do what I want. Thanks for any advice and sorry for the newbie question. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 13, 2008 Share Posted June 13, 2008 Use STR_TO_DATE(). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.