从数据库中提取时的CakePHP日期格式

Question

In my database, date of births are stored as Y-m-d format, for ex. 1965-09-04. When cakePHP is fetching is from the database, its internally converting these date to d/m/y format, so 1965-09-04 becomes 4/9/65.

Now when I try to convert this date to dd/mm/YY format (04/09/1965), it gives (04/09/2065).

Short story, I don't want cakephp to convert date formats while fetching from DB.

Answer 1

Found the answer. It was actually formatting date while data was going from controller to the view. Changed default date format of cakephp using bootstrap file. Added this in the file :

Cake\I18n\Date::setToStringFormat('YYYY-MM-dd');
Cake\I18n\FrozenDate::setToStringFormat('YYYY-MM-dd');

\Cake\Database\Type::build('date')
    ->useImmutable()
    ->useLocaleParser()
    ->setLocaleFormat('YYYY-MM-dd');

Reference : Cakephp 3.2 change default date format