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. Link to comment https://forums.phpfreaks.com/topic/110069-converting-input-form-date-in-mmddyyyy-to-store-in-mysql-date-field/ Share on other sites More sharing options...
fenway Posted June 13, 2008 Share Posted June 13, 2008 Use STR_TO_DATE(). Link to comment https://forums.phpfreaks.com/topic/110069-converting-input-form-date-in-mmddyyyy-to-store-in-mysql-date-field/#findComment-564892 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.