MongoDb等价于日期(从UNIXTIME(<<VALUE>>)和时间(从UNIXTIME(<<VALUE>>))

我有一个时间戳存储为unix时间(毫秒)和UTC查询参数的查询

select *
from my_table
where parameter1 = 'Goofy'
and DATE(FROM_UNIXTIME(time)) >= '2020-05-13 00:00:00.000 0000' --startdate
and DATE(FROM_UNIXTIME(time)) <= '2020-05-15 00:00:00.000 0000' --enddate
and TIME(FROM_UNIXTIME(time)) >= '01-01-1970 12:22:00.000 0000' --starttime
and TIME(FROM_UNIXTIME(time)) <= '01-01-1970 19:33:00.000 0000' --endtime

在Mongo(PHPAPI)中,我的查询如下

$query = [
    '$and' => [
         ['parameter1' => 'Goofy']
         ,['time' => [$gte =>  <conversion to unixtime for date '2020-05-13 00:00:00.000 0000' >]]
         ,['time' => [$lte  => <conversion to unixtime for date '2020-05-15 00:00:00.000 0000' >]]
         ,['time' => [$gte  => <conversion to unixtime for time '01-01-1970 12:22:00.000 0000' >]]
         ,['time' => [$lte  => <conversion to unixtime for time '01-01-1970 19:33:00.000 0000' >]]
]
];

$cursor = (new MongoDB\Client())->selectCollection('myDb', 'myTable')->find($query,[]);