Reset date format?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Lucas Malor
Registered User
Posts: 143
Joined: Tue Jun 28, 2005 7:12 pm
Contact:

Reset date format?

Post by Lucas Malor »

How can I reset the date format of all users to the forum default date format?
agent00shoe
Registered User
Posts: 373
Joined: Sat Feb 12, 2005 9:39 pm

Post by agent00shoe »

You can run this SQL query

Code: Select all

UPDATE `phpbb_users` SET user_dateformat = 'D M d, Y g:i a'
and replace

Code: Select all

D M d, Y g:i a


with the date format you want. That will change every single user's format to whatever you choose.
Lucas Malor
Registered User
Posts: 143
Joined: Tue Jun 28, 2005 7:12 pm
Contact:

Post by Lucas Malor »

All done :D thanks
Locked

Return to “2.0.x Support Forum”