topic Re: SQL CURRENT_TIMESTAMP in QlikView in QlikView

SQL CURRENT_TIMESTAMP in QlikView

CVR — Sat, 16 Nov 2024 21:50:47 GMT

Hello Qlik Geeks,

I have a SQL query ''DateFrom <= CURRENT_TIMESTAMP and DateTo > =CURRENT_TIMESTAMP'' and trying to apply this query in Qlik Extractor to pull the data from SQL and store into QVD. May I know what is the exact function I should replace CURRENT_TIMESTAMP in Qlik?

Thanks,

Reddy

Re: SQL CURRENT_TIMESTAMP in QlikView

dplr-rn — Wed, 21 Nov 2018 20:56:07 GMT

Use today () for date only or now() fot date and time.
You may need to format it according to your db field.

Alternatively you can use native current time/date function from db too

Re: SQL CURRENT_TIMESTAMP in QlikView

CVR — Wed, 21 Nov 2018 20:59:45 GMT

My DB date format is --'2000-01-01'

Re: SQL CURRENT_TIMESTAMP in QlikView

dplr-rn — Wed, 21 Nov 2018 21:04:27 GMT

Then put into a variable
Date (today (), 'YYYY-MM-DD')
Usr variable within your SQL statement something like below
Date>'$(yourvariable)'