MySQL Date & Time functionsMySQL have several date & time related functions to use in different situations and requirements. We will discuss some of the important functions here and use them for developing some sample codes. You can read php date & time functions.
From Date of Birth Calculate the retirement dateThe person will retire on the last working day of the retirement month.Group by in date field to count records of each dayGetting records of each day by using group by and count command in mysql date fieldData of different quarters of the yearDifferent Financial Quarter dataFormat to use for creating date string before storing in Date field.Date fields of MySQL table accept a particular format of Date & time strings, so we have to create such an acceptable format while storing Date values.Collecting date stored as string in varchar field.We can use str_to_date function to format date value stored as string in a varchar field ( not date field )Adding present date & time automatically to mysql tableWe can store the present date & time in a DateTime field while updating adding a record by using default value to CURRENT_TIMESTAMPFormatting returned date value using strtotime functionWe can format the returned date value from table by using strtotime function.Subscribe to our YouTube Channel here
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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
SQL Video Tutorials