different date for one day, (I add screenshot)

wardog · December 5, 2015, 4:58am

Hi

in my database a date is saved, but when I display it on the GridView adds one more day, my desire is to display and handle all dates in the format: d-m-Y

6839

Why more than 1 day is added to the actual date in the gridview?

My Yii version:

    &quot;php&quot;: &quot;&gt;=5.4.0&quot;,


    &quot;yiisoft/yii2&quot;: &quot;&gt;=2.0.4&quot;,


    &quot;yiisoft/yii2-bootstrap&quot;: &quot;*&quot;,


    &quot;yiisoft/yii2-swiftmailer&quot;: &quot;*&quot;,


    &quot;yiisoft/yii2-jui&quot;: &quot;^2.0&quot;

wardog · December 5, 2015, 3:44pm

somebody?

jacmoe · December 5, 2015, 4:14pm

Because your timezone is behind UTC?

Set the timezone in your application, to UTC.

wardog · December 5, 2015, 5:37pm

como hago eso?

in that file? that I place?

only one change this in php.ini:




[Date]

; Defines the default timezone used by the date functions

; http://php.net/date.timezone

date.timezone=America/Lima

jacmoe · December 5, 2015, 5:52pm

And what time zone is your database server set to be using?

I suspect that it is only in the evening that you get a days difference?

jacmoe · December 5, 2015, 6:01pm

Are you using TimestampBehavior or other things that uses the expression NOW() to generate timestamps?

That would use the time and timezone of the db server.

I make sure to set the timezone to UTC everywhere. It is easier to work with.

I also never use expressions like NOW() to generate timestamps, it’s too server specific.