I have a queries which retrieves invoices from a table.
But the getdate() is not an option in this case, because I use a ODBC driver.
When I use the below function there is no problem.
select
{fn NOW
()}
But this shows also the time.
By using
SELECT
{fn curdate
()}
I was able to avoid the time part.
My query looked like this
Select
top 10
* from openquery(Transoft
, '
select * from table
WHERE processDate = {fn curdate()}')
Transsoft = ODBC driver to connect to tables I us.