Pushpendra Singh Chauhan Posted October 22, 2021 Share Posted October 22, 2021 Hi if anyone can help please. I've an urgent requirement to change file submit / updated detail of a file. So I thought it may be done from backend easily. But as I can see in db table the date is not in usual format. What is the mechanism to change this ? Link to comment Share on other sites More sharing options...
ReyDev Posted October 22, 2021 Share Posted October 22, 2021 (edited) php-> timestamp to date date('m/d/Y H:i:s', 1541843467) you can also get the current timestamp in php with: $time = time(); // get current date and time in timestamp format as you have in your DB Edited October 22, 2021 by ReyDev Link to comment Share on other sites More sharing options...
Solution DawPi Posted October 22, 2021 Solution Share Posted October 22, 2021 https://www.unixtimestamp.com/ Link to comment Share on other sites More sharing options...
ReyDev Posted October 22, 2021 Share Posted October 22, 2021 16 minutes ago, Pushpendra Singh Chauhan said: Hi if anyone can help please. I've an urgent requirement to change file submit / updated detail of a file. So I thought it may be done from backend easily. But as I can see in db table the date is not in usual format. What is the mechanism to change this ? where do you want to control them? in php files or sql ? if you want to change them without code and query . you can use the website that @DawPi pointed Link to comment Share on other sites More sharing options...
Pushpendra Singh Chauhan Posted October 25, 2021 Author Share Posted October 25, 2021 (edited) On 10/22/2021 at 6:01 PM, ReyDev said: where do you want to control them? in php files or sql ? if you want to change them without code and query . you can use the website that @DawPi pointed In SQL. I need to modify the detail of one file only so I thought it would be better to change through backend instead of custom code. thanks @ReyDev @DawPi Edited October 25, 2021 by Pushpendra Singh Chauhan Link to comment Share on other sites More sharing options...
Recommended Posts