Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Pushpendra Singh Chauhan Posted October 22, 2021 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 ?
ReyDev Posted October 22, 2021 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
Solution DawPi Posted October 22, 2021 Solution Posted October 22, 2021 https://www.unixtimestamp.com/
ReyDev Posted October 22, 2021 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
Pushpendra Singh Chauhan Posted October 25, 2021 Author 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
Recommended Posts