MySQL Date and Time

<< Back to MYSQL

next → ← prev Literals: Date and Time In MySQL programming, Date and Time literals are in the form of strings or numbers. Following are some more formats in which date and time can be displayed. EXAMPLE FORMAT '2018-10-18' 'YYYY-MM-DD' '20181018' 'YYYYMMDD' 20181018 YYYYMMDD '18-10-18' 'YY-MM-DD' 181018 YYMMDD '2018-10-18 5:25:20' 'YYYY-MM-DD HH:MM:SS' '2018101852520' 'YYYYMMDDHHMMSS' 2018101852520 YYYYMMDDHHMMSS '18-10-18 5:25:20' 'YY-MM-DD HH:MM:SS' '18101852520' 'YYMMDDHHMMSS' 18101852520 YYMMDDHHMMSS Example 1 select id, name, salary, date_format(sal_date,'%d-%m-%y') as new_date_formate from staff1; Example 2 select id, name, salary, date_format(sal_date,'%d%m%y') as new_date_formate from staff1; Next TopicMySQL Procedure ← prev next →

Related Links:

• MySQL Create Database
• MySQL DAYOFWEEK() Function
• MySQL DAYOFYEAR() Function
• MySQL From_days() Function
• MySQL Hour() Function
• MySQL ADDTIME() Function
• MySQL CURRENT_TIME() Function
• MySQL CURRENT_TIMESTAMP() Function
• MySQL last_day() Function
• MySQL localtime() Function
• MySQL localtimestamp() Function
• MySQL makedate() Function
• MySQL maketime() Function
• MySQL microsecond() Function
• MySQL minute() Function
• MySQL month() Function
• MySQL vs SQL
• MySQL monthname() Function
• MySQL now() Function
• MySQL period_add() Function
• MySQL period_diff() Function
• MySQL quarter() Function
• MySQL sec_to_time() Function
• MySQL Sysdate() Function
• MySQL second() Function
• MySQL Subdate() Function
• MySQL Subtime() Function
• MySQL time() Function
• MySQL time_to_sec() Function
• MySQL time_format() Function
• MySQL to_day() Function
• MySQL timediff() Function
• MySQL timestamp() Function
• MySQL weekday() Function
• MySQL Math SIN() Function
• MySQL week() Function
• MySQL weekofyear() Function
• MySQL Math
• MySQL Math ABS() Function
• MySQL Math ACOS() Function
• MySQL Math SIGN() Function
• MySQL Math SQRT() Function
• MySQL Math SUM() Function
• MySQL Math TAN() Function
• MySQL Math ATAN2() Function
• MySQL Drop Table
• MySQL View
• MySQL Queries
• MySQL Insert Statement
• MySQL Update Statement
• MySQL Math TRUNCATE() Function
• MySQL Math ASIN() Function
• MySQL Math ATAN() Function
• MySQL Math MIN() Function
• MySQL Math AVG() Function
• MySQL Math CEIL() Function
• MySQL Math CEILING() Function
• MySQL Math COS() Function
• MySQL Math COT() Function
• MySQL Math COUNT() Function
• MySQL Math DEGREES() Function
• MySQL Math DIV() Function
• MySQL Math EXP() Function
• MySQL Math FLOOR() Function
• MySQL Math GREATEST() Function
• MySQL Math LEAST() Function
• MySQL Math LN() Function
• MySQL Math LOG10() Function
• MySQL Math LOG() Function
• MySQL Math LOG2() Function
• MySQL Math MAX() Function
• MySQL Math MOD() Function
• Learn MySQL Tutorial
• MySQL Math PI() Function
• MySQL Math POWER() Function
• MySQL Math POW() Function
• MySQL Math RADIANS() Function
• MySQL Math RAND() Function
• MySQL Math ROUND() Function
• MySQL String
• MySQL String CONCAT_WS() Function
• MySQL String CHARACTER_LENGTH() Function
• MySQL String CONCAT() Function
• MySQL String ELT() Function
• MySQL String EXPORT_SET() Function
• MySQL String RTRIM() Function
• MySQL String FIELD() Function
• MySQL String FIND_IN_SET() Function
• MySQL String FORMAT() Function
• MySQL String FROM_BASE64() Function
• MySQL String HEX() Function
• MySQL String INSERT() Function
• MySQL String INSTR() Function
• MySQL String LCASE() Function
• MySQL String LEFT() Function
• MySQL String LENGTH() Function
• MySQL String like() Function
• MySQL String LOAD_FILE() Function
• MySQL String LOCATE() Function
• MySQL String LOWER() Function
• MySQL String LPAD() Function
• MySQL String LTRIM() Function
• MySQL String MAKE_SET() Function
• MySQL String MID() Function
• MySQL String OCTET_LENGTH() Function
• MySQL String OCT() Function
• MySQL String ORD() Function
• MySQL String POSITION() Function
• MySQL String QUOTE() Function
• MySQL String REPEAT() Function
• MySQL String REPLACE() Function
• MySQL String REVERSE() Function
• MySQL String SPACE() Function
• MySQL String RIGHT() Function
• MySQL String RPAD() Function
• MySQL String SOUNDEX() Function
• MySQL String UNHEX() Function
• MySQL String UCASE() Function
• MySQL String STRCMP() Function
• MySQL String SUBSTR() Function
• MySQL String SUBSTRING_INDEX() Function
• MySQL String SUBSTRING() Function
• MySQL String Trim() Function
• MySQL String UPPER() Function
• MySQL Drop Database
• MySQL Create Table
• MySQL Alter Table
• MySQL Truncate Table
• MySQL Delete Statement
• MySQL Select Statement
• MySQL Group By Clause
• Top 58 MySql Interview Questions (2021)
• MySQL Features
• MySQL Data Types
• MySQL regexp_like() function
• MySQL regexp_replace() Function
• MySQL regexp_substr() function
• MySQL Select Database
• MySQL Where Clause
• MySQL Distinct Clause
• MySQL From Clause
• MySQL Order By Clause
• MySQL Having Clause
• MySQL AND Condition
• MySQL average()
• MySQL min()
• MySQL max()
• MySQL Literals
• MySQL OR Condition
• MySQL AND and OR Condition
• MySQL IS NULL Condition
• MySQL LIKE Condition
• MySQL IN Condition
• MySQL NOT Condition
• MySQL IS NOT NULL Condition
• MySQL first()
• MySQL BETWEEN Condition
• MySQL Join
• MySQL count()
• MySQL sum()
• MySQL last()
• MySQL Comments
• MySQL not regexp Operator
• MySQL Regexp Operator
• MySQL regexp_instr() function
• MySQL Cursor
• MySQL Functions
• MySQL Date and Time
• MySQL PROCEDURE
• MySQL Trigger
• MySQL not like Operator
• MySQL date/time
• MySQL DATE() Function
• MySQL DATE_ADD() Function
• MySQL ADDDATE() Function
• MySQL CURDATE() Function
• MySQL CURRENT_DATE() Function
• MySQL DATE_FORMAT() Function
• MySQL DATEDIFF() Function
• MySQL DAY() Function
• MySQL CURTIME() Function
• MySQL DAYNAME() Function
• MySQL DAYOFMONTH() Function
• MySQL str_to_date() Function

Related Links