Absent Member.. Jennifer_Tilly Absent Member..
Absent Member..
109 views

Database query result compared to date

Hey Guys,

 

I have a database query that recieves a result as date (dd/mm/YYYY). I would like to compare the result in the trhesholds against TODAY date(the time the monitor ran).

 

Is using functions like DATE are possibole within sitescope thresholds?

 

Thanks,

J

Labels (1)
0 Likes
1 Reply
Micro Focus Expert
Micro Focus Expert

Re: Database query result compared to date

No. You need to find a way to embed the comparison operation in the SQL query itself. 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.