str_to_date(string_data, format)
If the format is not supported by the string data given then the output will be NULL. For any illegal date or time string value also the output will be NULL.
SELECT STR_TO_DATE('12/15/2008', '%m/%d/%Y');
Output of above query is 2008-12-15STR_TO_DATE('Dec/15/2008', '%M/%d/%Y'); => 2008-12-15
STR_TO_DATE('31/Jan/2008', '%d/%M/%Y'); => 2008-01-31
STR_TO_DATE( '31/Jan/2008 23:52', '%d/%M/%Y %H:%i' ) => 2008-01-31 23:52:00
Try with some illegal date
STR_TO_DATE( '32/Apr/2008', '%d/%M/%Y' ) => NULL
Learn how str_to_date is used to format date value stored as text in Varchar field of MySQL table
vicky | 01-07-2012 |
Thanks a lot, this has been very helpful |
dhamu | 14-07-2013 |
hi. i have two radio button. one button for show login datetime and another button for logout datetime to show. when i click login button it should store login datetime then after that if i click logout button it should store logout time. i want to store login & logout datetime in mysql using php. please help me . |