Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Interval usage? |
Thu, Apr 30 2020 1:56 AM | Permanent Link |
Ian Branch | Hi Team,
I don't seem to be reading the Help correctly. I have the following as part of a where in a sql query.. {sql} ... and (JobStatus = 'CL') and ((Current_TimeStamp - DateClosed) > Interval '5' DAY) ... {sql} DateClosed is a TimeStamp field in the table. I am wanting the condition to be true when the the DateClosed is more than 5 days ago. What have I missed please? Regards & TIA, Ian |
Thu, Apr 30 2020 1:58 AM | Permanent Link |
Ian Branch | Missed some info.
I get the following error when the query is executed in EDBMgr. "ElevateDB Error #700 An error was found in the statement at line 3 and column 64 (Expected Interval Day To MSecond expression but instead found INTERVAL '5' DAY)" |
Thu, Apr 30 2020 3:31 AM | Permanent Link |
Ian Branch | All sorted.
{sql} and (Current_Date - Cast(DateClosed as Date)) > interval '5' day {sql} Thanks for looking. Ian |
This web page was last updated on Monday, April 22, 2024 at 04:13 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |