Setting data explorer dates

Hi @pauhana,

You can change the date format in plugin settings. Just scroll down on tab plugin until you find the date format setting.

Does this help?
Peter

Still unclear.

Here is a screenshot of my current settings for dates:
https://ibb.co/GnmbXsg

My date has been confirmed correct, but shows up within the Data Explorer as
“November 30, -0001 12:00 am”. Given the date output setting, I was expecting
“April 11, 2022”.

Where am I going wrong?

Thanks for the help!

Sorry, wrong graphic.

Date format output (WordPress format) is given as “F j, Y”.

Hi @pauhana,

How do you store the timestamp? Can you share the code?

What output do you get from a stand query in the Query Builder?

Thanks,
Peter

Here’s a snippet of my code:

      $today = strtotime('today PST');
      if ($today !== false) {
        //DBG $page_text .= 'Today is [' . date("Y-m-d", $today) . ']</br>';
        $db_columns = array('svs_seed_order_date' => $today,
                            'svs_seed_order_member_id' => $user_id,
                            'svs_seed_order_set_id' => $new_seed_set_id);
        $wpdb->insert('svs_seed_order', $db_columns, array('%d', '%d','%d'));
      } else {
        $msg = "Internal error: Problem determining today's date.";
      }

As I say, the value stored has been confirmed to be fine.

Please let me know if there is a better way to go about storing the date…

Oh, and as to your second question, the query builder shows the date values to be zeroed out; the date column shows as “0000-00-00 00:00:00”.

Hi @pauhana,

I think your code snippet is the problem. The strtotime return an int which MySQL interprets as a wrong format, resulting in a datetime with all zeros. With wpdb->insert it’s better to use current_time:
https://developer.www.ads-software.com/reference/functions/current_time/

Does this solve the issue?

Thanks,
Peter

Thank you Peter.

I ended up having so much trouble trying to get a date interpreted properly, I ended up just storing it as a string. Not optimal, but good enough.

Thanks again for the help.

Hi @pauhana,

Not sure if this is applicable to your situation, but the simplest solution to get rid of these manual actions is to let your DBMS do this for you:

alter table svs_seed_order modify svs_seed_order_date datetime default current_timestamp on update current_timestamp

When you remove column svs_seed_order_date from all your insert and update statements your DBMS will keep it up to data for you.

Hope this helps,
Peter