String to Date format by str_to_date()
We have to use particular format for date & time data before storing to MySQL date field. So if a user entered data is to be stored in a table then we have to change the format by using different string functions and convert them to acceptable date format. You can read this tutorial to know how the string functions are used to format the user entered data to MySQL table.
Video Tutorial on Inserting Date to Query
By using the function str_to_date() we can convert the string data to MySQL required format of date field. This function requires the string data and the format in which it is available.
str_to_date(string_data, format) Now let us try with some examples of this str_to_date function and its outputs.
SELECT STR_TO_DATE('12/15/2008', '%m/%d/%Y'); Same way here are some examples and the outputs of str_to_date function for your understanding
STR_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
STR_TO_DATE( '32/Apr/2008', '%d/%M/%Y' ) => NULLSQL Date References Storing date in MySQL date field
This article is written by plus2net.com team.
https://www.plus2net.com
▼ More on Date & Time functions in SQL
Date & Time functions used in Query for MySQL TableGetting formatted date value from date field in MySQLdate_add function to calculate date & time of MySQL tableFormatting date and time before adding to date field of MySQLString data to Date & time Format by using str_to_dateFormatting string data stored in varchar field to date valueAutomatically updating / inserting current date and time value in a DATETIME fieldRecords of each day by using group by commandCollecting records between two date ranges from MySQL table fieldsGenerating query based on user inputs of date from two calendarsGetting date values from MYSQL table in readable format including timeDifference in days between two date fieldsGetting the year part from date fieldGetting the month part from date fieldGetting the day part from date fieldRecords of today or records of last X seconds by using curdate() or unix_timestampRecords of last one month from today by using date fieldRecords of present week days by using dayofweek function| 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 . | |
SQL Video Tutorials