how to use utc timestamp symfony 4?

Question

How to use utc_timestamp in Symfony 4?

Getting below message while using utc_timestamp

[Semantical Error] line 0, col 199 near 'UTC_TIMESTAMP': Error: 'UTC_TIMESTAMP' is not defined.

Is there any code involved that you want to share? That's not an error thrown by Symfony itself — Nico Haase
– Nico Haase, Commented Apr 10, 2019 at 12:52
@NicoHaase i tried this but not working This is doctirne dql query @$qb->andWhere("(pv.appointmentDate) >= UTC_TIMESTAMP"); — ankit parmar
– ankit parmar, Commented Apr 10, 2019 at 13:00
Please add everything that is relevant into the question, don't use the comment section for that. And: obviously, you are using any random string and not a function in your code. Have a look at github.com/beberlei/DoctrineExtensions — Nico Haase
– Nico Haase, Commented Apr 10, 2019 at 13:03
@NicoHaase i want to use like this: stackoverflow.com/questions/55624934/… — ankit parmar
– ankit parmar, Commented Apr 11, 2019 at 4:53
You're welcome to do so, but you have to do something for it. It won't work out of the box — Nico Haase
– Nico Haase, Commented Apr 11, 2019 at 7:08

Mitesh Vasava · Accepted Answer · 2019-04-10 12:54:53Z

1

I think you need to use utc_timestamp with doctrine. you can include library in doctrine.yaml file.

orm:
        dql:
            string_functions:
                UTC_TIMESTAMP: DoctrineExtensions\Query\Mysql\UtcTimestamp

Check with above code. Might be helpful.

answered Apr 10, 2019 at 12:54

Mitesh Vasava

7357 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mitesh Vasava · Accepted Answer · 2019-04-10 13:13:35Z

1

It seems there is wrong way to use it. UTC_TIMESTAMP use with parentheses. it should like:

$qb->andWhere("(pv.appointmentDate) >= UTC_TIMESTAMP()");

answered Apr 10, 2019 at 13:13

Mitesh Vasava

7357 silver badges13 bronze badges