db icon indicating copy to clipboard operation
db copied to clipboard

Supports PHPs DateTime instances

Open Tigrov opened this issue 11 months ago • 2 comments

Doctrine and Cycle support PHPs DateTime instances

https://www.doctrine-project.org/projects/doctrine-orm/en/2.15/cookbook/working-with-datetime.html

https://cycle-orm.dev/docs/advanced-datetime/current

It would be great if yiisoft/db could support PHPs DateTime instances for types timestamp, datetime, date and time.

$command->insert('datetime_table', ['datetime' => new DateTime()])->execute();
$datetime = (new Query($db))->select(['datetime'])->from('datetime_table')->scalar();
$datetimePhpType = $tableSchema->getColumn('datetime')->phpTypecast($datetime);
$datetimePhpType instanceof DateTimeInterface;

I can realize if you agree.

Tigrov avatar Jul 09 '23 09:07 Tigrov

Yes, that is very convenient.

samdark avatar Jul 10 '23 14:07 samdark

Good, I implement

Tigrov avatar Jul 10 '23 15:07 Tigrov