What is the best way to organize date formatting in yii and at what stages to do it?

Question

Yii

There is a sql server with its datetime format 2014-01-13 11:40:34.423
There is a need to edit the date and time in some forms and save the changes.
The user needs to give the human date and time format 01/13/2014 and 11:40:34, and save it in the database in datetime format.
What is the best way to organize date formatting and at what stages to do it?

Answer 1

I store int.
When entering into fields when creating a new entity or searching / filtering a human date (Ymd) in beforeValidate, I translate to unixtime.
When outputting unixtime, I translate to Ymd

public function beforeValidate()
  {
    $attrs = [ 'time', 'testing', 'call' ];
    foreach ( $attrs as $attr ) {
      $time = \DateTime::createFromFormat( 'Y-m-d H:i:s', $this->$attr );
      if ( !$time ) continue;
      $this->$attr = $time->format( 'U' );
    }

    parent::beforeValidate();
    return true;
  }

Answer 2

On withdrawal, of course. It is possible even on js.

Answer 3

There is CDateFormatter .
But if DateTime is enough for you, then there is nothing criminal in using it. Theoretically, this will complicate design changes and localization, but in practice, everything still has to be shoveled.
Of course, it is better to do date conversion in the template, where it is displayed.

Answer 4

SELECT DISTINCT table FROM from_table GROUP BY table

Answer 5

Can:
SELECT DISTINCT field_1, field_2 FROM table

Answer 6

What's the problem?
Select by condition ( WHERE ) all rows with the desired type , then group ( GROUP BY ) by type and sort ( ORDER BY ) by primary key.
Well, or through DISTINCT