change date format while displaying date column from database Yii

Question

while displaying data from database in my yii webapp i want to change the date format of my date column from yyyy-mm-dd to dd-mm-yyyy ..

code in my view for date of birth column.

<?php echo CHtml::encode($data->getAttributeLabel('Date Of Birth')); ?>
<?php echo CHtml::encode($data->dob); ?>

Krish R · Accepted Answer · 2014-10-14 16:13:43Z

1

Can you try this,

 Yii::app()->dateFormatter->formatDateTime(
                CDateTimeParser::parse(
                    $data->dob, 
                    'dd-mm-yyyy'
                ),
                'short',null
            );

Ref: http://www.yiiframework.com/wiki/183/using-international-dates/

http://www.yiiframework.com/doc/api/1.1/CDateFormatter

answered Oct 14, 2014 at 16:13

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2023-11-17 20:24:57Z

0

You can use DateTime

Create a DateTime object with the value you have now
Reformat the object to the desired format.

<?php

$date = DateTime::createFromFormat('Y-m-d', $data->dob);
echo $date->format('d-m-Y');

https://eval.in/205827

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Oct 14, 2014 at 16:11

ʰᵈˑ

11.4k3 gold badges31 silver badges50 bronze badges

2 Comments

ʰᵈˑ Over a year ago

You're welcome - However, as you're using Yii, it may be worthwhile using @KrishR answer. (I've never used Yii, so...)

ʰᵈˑ Over a year ago

Ah okay :) I'm glad I gave an alternative solution then

Collectives™ on Stack Overflow

change date format while displaying date column from database Yii

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related