PHP ebi Q::date_format示例

示例#1

文件： date_format_distinct.php 项目： tokushima/ebi

<?php

use ebi\Q;
\test\db\DateTime::find_delete();
(new \test\db\DateTime())->ts('2015/07/21 12:13:14')->save();
(new \test\db\DateTime())->ts('2015/07/22 12:13:14')->save();
(new \test\db\DateTime())->ts('2015/07/23 13:13:14')->save();
(new \test\db\DateTime())->ts('2015/07/21 14:13:14')->save();
eq(['2015-07-21T00:00:00', '2015-07-22T00:00:00', '2015-07-23T00:00:00'], \test\db\DateTime::find_distinct('ts', Q::date_format('ts', 'Ymd')));
eq(['2000-01-01T12:00:00', '2000-01-01T13:00:00', '2000-01-01T14:00:00'], \test\db\DateTime::find_distinct('ts', Q::date_format('ts', 'H')));

示例#2

文件： date_format.php 项目： tokushima/ebi

$obj = new \test\db\DateFormat();
$obj->ts($date);
$obj->num(10);
$obj->save();
foreach (\test\db\DateFormat::find() as $o) {
    eq(date('c', $date), $o->fm_ts());
}
foreach (\test\db\DateFormat::find(Q::date_format('ts', 'Ym')) as $o) {
    eq(date('c', strtotime('2015/07/01 00:00:00')), $o->fm_ts());
}
$date = strtotime('2015/07/01 12:34:56');
$obj = new \test\db\DateFormat();
$obj->ts($date);
$obj->num(20);
$obj->save();
$date = strtotime('2015/07/30 12:34:56');
$obj = new \test\db\DateFormat();
$obj->ts($date);
$obj->num(30);
$obj->save();
foreach (\test\db\DateFormat::find(Q::date_format('ts', 'Ym')) as $o) {
    eq(date('c', strtotime('2015/07/01 00:00:00')), $o->fm_ts());
}
$date = strtotime('2015/08/30 12:34:56');
$obj = new \test\db\DateFormat();
$obj->ts($date);
$obj->num(40);
$obj->save();
eq(4, sizeof(\test\db\DateFormat::find_sum_by('num', 'ts')));
eq(2, sizeof(\test\db\DateFormat::find_sum_by('num', 'ts', Q::date_format('ts', 'Ym'))));