mardi 24 avril 2018

Database timestamp mismatch(No clock mismatch)

When downloaded a sql file(Mysql Database) created_at(timestamp) field shows the right time(EX: when I create a post or other activity) But when I see the same thing in Mysql Client(navicat/phpMyadmin) and when I fetch the field data(created_at) it shows me 6 hour updated time.

Here same data (same post) on different viewer:

1. Image from web application:

enter image description here

1. Image from mysql client software(Navicat):

enter image description here

3. SQL Insert Query from SQL file(that download from backup)(this data is actual(fully correct)):

INSERT INTO `posts` VALUES (1,'Fieoze Ahmed','2017-01-01 10:27:35');

How does it happen automatically ?

we are using:

  • Laravel
  • amazon EC2 Hosting
  • MySql Database


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire