Home >> MySql >> FORMAT() aggregate function in MySql

FORMAT() aggregate function in MySql

FORMAT() find format how a field is to be displayed.

Syntax

FORMAT(column_name,format)

Exapmle

SELECT name,city, FORMAT(Now(),'YYYY-MM-DD') AS curdate FROM products;

Output

Soap     delhi      2017-05-11

Oil         delhi      2017-05-11

Post Your Comment

Next Questions
COUNT() aggregate function
LOWER() aggregate function
UPPER() aggregate function
INITCAP() aggregate function
SUBSTR() aggregate function
ASCII() aggregate function
LENGTH() aggregate function
TRIM() aggregate function
LTRIM() aggregate function
RTRIM() aggregate function
What is transaction
What is normalization and types of normalization
What is First Normal Form(1NF)
What is Second Normal Form(2NF)
What is Third Normal Form(3NF)
What is Boyce Codd Normal Form(BCNF)
What is Fourth Normal Form(4NF)
What is Fifth Normal Form(5NF)
What is Index and why use indexing
What is clustered index
What is non clustered index
What is primary key index
What is unique key index
What is normal index
What is full text index

Copyright ©2022 coderraj.com. All Rights Reserved.