MySQL query insert current time [closed]

Solution 1:

Use:

SELECT DATE_FORMAT(FROM_UNIXTIME(1642633200),'%a,%d-%b-%Y');

Replace 1642633200 with your column name date_added

First you need to convert your date using FROM_UNIXTIME and then give your desired format using DATE_FORMAT

Result:

DATE_FORMAT(FROM_UNIXTIME(1642633200),'%a,%d-%b-%Y')
Wed,19-Jan-2022

Demo

Check MySQL doc for more info