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:
1. Image from mysql client software(Navicat):
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