Find the best answer to your question, help others answer theirs
If you are going to use a passage of Lorem Ipsum, you need to be sure there
isn't anything embarrassing hidden in the middle of text.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
1 Answer
- CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to combine two or more fields into one single field.
- FORMAT(X, D) – Formats the number X to D significant digits.
- CURRDATE(), CURRTIME() – Returns the current date or time.
- NOW() – Returns the current date and time as one value.
- MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() – Extracts the given data from a date value.
- HOUR(), MINUTE(), SECOND() – Extracts the given data from a time value.
- DATEDIFF(A, B) – Determines the difference between two dates and it is commonly used to calculate age
- SUBTIMES(A, B) – Determines the difference between two times.
- FROMDAYS(INT) – Converts an integer number of days into a date value.
-
1Ah excellent! Thank you! - Arden Smith - 8 hours ago
Add a comment
