Happy Business Starts Here

Is DateDiff function works in DataQuery?

salimthakkar
Zuora Support

Is DateDiff function works in DataQuery?

Question: Customer wants to know DateDiff function is supported in data query and what other functions are supported?

 

Solution: Date_diff is supported and the file is accurate, Those functions available in data query, and also you can check the various data functions by running the query, i.e SHOW FUNCTIONS in the data query.

 

Sample Query using the Date_diff:

SELECT date_diff('day', DATE '2020-03-01', DATE '2020-03-02')

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
sayam
Valued Scholar

Re: Is DateDiff function works in DataQuery?

Hi Salim,

 

Can you please tell me the exact requirement you have?
You can work with dates with <, >, = operators

Date function works properly but more for extensive usage, you might need export ZOQL.

you can even look at the below web page for more reference:


https://knowledgecenter.zuora.com/Central_Platform/Query/Data_Query/Best_practices_when_writing_SQL

Tags (1)