Question

1. Explain date time functions and string functions.in my sql

Answer 1

1. Date time functions in MySQL: They are used for a description of the range of values each date and time type has and the valid formats in which values may be specified. Few syntaxes are:

(a) ADDDATE() - adds date

(b) ADDTIME() - adds time

(c) CURDATE() - returns current date

(d) CURTIME() - returns current time

(e) DATE() - Extracts the date part of a date or datetime expression

(f) LAST_DAY() - Returns the last day of the month for the argument

2. String functions in MySQL:

(a) CHAR_LENGTH() - Returns the length of a string

(b) ASCII() - Returns the ASCII value for the specific character

(c) CONCAT() - Adds two or more expressions together

(d) LENGTH() - Returns the length of a string

(e) REVERSE() - Reverses a string and returns the result

(f) TRIM() - Removes leading and trailing spaces from a string