FORMAT() find format how a field is to be displayed.
SELECT name,city, FORMAT(Now(),'YYYY-MM-DD') AS curdate FROM products;
Soap delhi 2017-05-11
Oil delhi 2017-05-11
Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.
Copyright ©2022 coderraj.com. All Rights Reserved.