Query report - date
Hi all,
I need a help with MySQL to make a where clause that shows me only the lines where CompletedTime = CompletedTime - 1 day.
I know that in Oracle would be something like this:
(TRUNC(wo.crompletedime)>TRUNC(SYSDATE)-1)
The rest of the query is ready, I'm only stuck in this where clause.
My SQL is Linux Based.
Tks in adv,
Thaiz Cabral
I need a help with MySQL to make a where clause that shows me only the lines where CompletedTime = CompletedTime - 1 day.
I know that in Oracle would be something like this:
(TRUNC(wo.crompletedime)>TRUNC(SYSDATE)-1)
The rest of the query is ready, I'm only stuck in this where clause.
My SQL is Linux Based.
Tks in adv,
Thaiz Cabral