We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3960198
WPdatatable is not recording local timezone
Open

Comments

  • Dinesh P started the conversation

    I would like to know if there is any way to show the time/date calculated using the user's local time zone.

    i.e., we show the post date (UTC), the post_date_gmt (Australia/Sydney +10 UTC), and we want to show the post date in local user time, like Sydney. 

    All the server time has been set up correctly, and the Hosting provider has checked that there is nothing to set on the server. 

    Currently, created at, last edited are showing the incorrect date. 

  •  1,895
    Miloš replied

    Hello,

    My sincerest apologies—we encountered significant issues with our ticketing system.

    Some tickets were mistakenly marked as "replied" even though they hadn’t received a response, which caused us to miss them.

    It looks like the issue has been resolved now, but we've also implemented a new support system that you can access directly on our site. Just click the little chat box in the bottom right corner. 2108883896.pngFirst, our AI assistant will attempt to help with your questions or issues. It continuously learns and improves, but if it doesn't resolve your issue, it will connect you with us directly.

    5216122788.png
    Thank you for your patience.

    In regard to this issue/use case :
    Sorry to disappoint you, but if you plan to have an 'auto-fill' specific time zone during editing - to change the way how the Date/Time value is stored, our Plugin does not have a feature like this.

    As mentioned on your other ticket, where we wrote about SQL time zones for values:

    The plugin pulls data directly from your database, and by default, all database entries are saved in the UTC+0 time zone.
    This is not an issue caused by the plugin—it’s simply the standard way SQL databases handle date/time values.

    To display times in your local time zone, you’ll need to make an SQL Query-based table to call the data from your original Manual(editable table).
    First, check what is the MySQL Table name in the editing settings, then make an additional SQL Query table and call it like :
    SELECT * FROM TableName.

     Now, in order to get your desired time zone for these values, you will need to adjust the values within your SQL query using the MySQL CONVERT_TZ() function:

    CONVERT_TZ(datetime_value, from_timezone, to_timezone)

     

    This function converts a datetime value from one time zone to another.
    Note: If the arguments are invalid, MySQL will return NULL.

    Here is an example from another user. They tried this:

    SELECT
      CONVERT_TZ('2020-12-01 01:00:00', '+00:00', '+02:00') AS slot_start
    FROM table_name



    Later, they updated it to use the actual column name instead of a hardcoded date:


    SELECT
      CONVERT_TZ(slot_start, '+00:00', '+02:00') AS Slot_Start
    FROM table_name

     

    This worked successfully in their case.
    You can adjust the +02:00 to your preferred time zone as needed.

     

    Please Note:
    If you're encountering an error with your query, we kindly ask for your understanding—our support does not include writing or debugging custom SQL queries, as that falls under custom development work.

    We recommend checking out MySQL documentation or using publicly available resources and tools like ChatGPT, which can assist you in identifying and correcting errors in your query.

    We hope this helps point you in the right direction.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables