Changing DataBase Time Stamps Print

If you’re using 4GoodHosting and you want to change database timestamps, here are some common scenarios and solutions depending on what exactly you’re trying to do:

 

Scenario 1: Change Timezone of MySQL/MariaDB

To make sure all your timestamps reflect the correct local time (e.g., your timezone):

✅ Solution:

1. Set timezone in MySQL session (temporary):

   sql

    

   SET time_zone = 'America/Toronto';

2. Set default timezone in my.cnf (server-wide):

   • Find and edit the my.cnf file (you’ll need root access for VPS/Dedicated hosting):

     ini

      

     [mysqld] default-time-zone='America/Toronto'

   • Restart MySQL service.

3. PHP-level timezone setting (if timestamps are from PHP scripts):

   php

    

   date_default_timezone_set('America/Toronto');

 Scenario 2: Update Specific Timestamp Values in a Table

To manually change timestamps in a particular row or column:

✅ Solution:

 Scenario 3: Automatically Use Current Time for Timestamps

To make a column always record the current time:

✅ Solution:

Or if you want it to update on every row change:

 

 

 4GoodHosting Shared Hosting Consideration

If you're on shared hosting, you may not have root access to modify my.cnf. In that case:

• Use SET time_zone at the start of your SQL scripts.

• Use PHP's date_default_timezone_set() before interacting with the database.