通过 
搜索
搜索y0lk / php-mysql-interval
将 DateInterval 转换为 MySQL 时间间隔表达式
0.1
2018-11-21 03:01 UTC
Requires
- php: >=7.1.0
Requires (Dev)
- phpunit/phpunit: ^7.4
This package is auto-updated.
Last update: 2024-09-21 20:36:09 UTC
README
一个小巧的 PHP 类，用于将 DateInterval 对象转换为 MySQL 时间间隔表达式
安装
通过 Composer
$ composer require y0lk/php-mysql-interval
使用方法
use Y0lk\MySQLInterval\MySQLInterval; //---Example with a DateInterval create from an interval specification echo MySQLInterval::fromDateInterval(new DateInterval("P1D"), "DAY"); //Outputs "INTERVAL 1 DAY" //---Example using diff between 2 dates $date1 = new DateTime("2000-01-01 05:20:11.000000"); $date2 = new DateTime("2000-01-21 12:55:33.123456"); $interval = $date1->diff($date2); $expr = MySQLInterval::fromDateInterval($interval, "DAY_MICROSECOND"); //Ouputs "INTERVAL '20 7:35:22.123456' DAY_MICROSECOND" //---Example using a date string with fromDateString() echo MySQLInterval::fromDateString("300 days + 7 hours", "DAY_HOUR"); //Outputs "INTERVAL '300 7' DAY_HOUR"
许可证
MIT 许可证 (MIT)。更多信息请参阅 许可证文件。