STR_TO_DATE('Dec/15/2008', '%M/%d/%Y'); => 2008-12-15
SELECT STR_TO_DATE('31/Jan/2008', '%d/%M/%Y'); => 2008-01-31
SELECT STR_TO_DATE( '12/01/2023', '%d/%m/%Y' ); => 2023-01-12
SELECT STR_TO_DATE( '31/Jan/2008 23:52', '%d/%M/%Y %H:%i' ) => 2008-01-31 23:52:00
SELECT STR_TO_DATE( '31/01/2023 23:52', '%d/%m/%Y %H:%i' ); => 2023-01-31 23:52:00
We have to use particular format for date & time data before storing to MySQL date field.
YYYY-mm-dd
Example: 2005-12-26 YYYY-mm-dd H:i:s
Example: 2005-12-26 23:50:30str_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( '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 . |