PHP MySQL: Getting year, month, day, hour, minute and second from DATETIME field

We all need to extract day, month and year from date provided.

For this, we often explode() the provided input and then get the required elements from the array.

There is a strong option to this.

Use substr() to get sub-string.

In Database, DATE and DATETIME fields have specified lengths.

We can use substr() in that case.

Examples:

For DATETIME:
    $dt = '2015-07-20 11:23:56';
    echo "<br/> Date: " . $dt;
    echo "<br/> Year: " . substr($dt, 0, 4);
    echo "<br/> Month: " . substr($dt, 5, 2);
    echo "<br/> Day: " . substr($dt, 8, 2);
    echo "<br/> Hour: " . substr($dt, 11, 2);
    echo "<br/> Minute: " . substr($dt, 14, 2);
    echo "<br/> Second: " . substr($dt, 17, 2);
For DATE:
    $dt = '2015-07-20';
    echo "<br/> Date: " . $dt;
    echo "<br/> Year: " . substr($dt, 0, 4);
    echo "<br/> Month: " . substr($dt, 5, 2);
    echo "<br/> Day: " . substr($dt, 8, 2);

Yii 1.1: Add jQuery UI datepicker to multiple input date fields.

In the following way, you can add jQuery UI datepicker to your Yii site.

$this->widget('zii.widgets.jui.CJuiDatePicker',array(
    'name'=>'publishDate',
    // additional javascript options for the date picker plugin
    'options'=>array(
        'showAnim'=>'fold',
    ),
    'htmlOptions'=>array(
        'style'=>'height:20px;'
    ),
));
You can even add date picker to more than one elements.
For example, you have two date fields with ids:
joining_date and increment_date
Then you can add these two dates in array like:
$dateFields = array('joining_date', 'increment_date');
if (! empty($dateFields)) {
// See here, you can add run time fields.
$dateFieldIds = implode(',#', $dateFields);
$this->widget('zii.widgets.jui.CJuiDatePicker',array(
  'name' => $dateFieldIds, 
  'options'=>array('showAnim'=>'fold',),
  'htmlOptions'=>array('style'=>'height:20px; display:none;'),
 ));
}

Reference:

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