Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Select filterd by months |
Sat, Nov 21 2009 5:58 AM | Permanent Link |
"Sorin H" | Hello
I try to create a sql statement where the result are filter by months difference. The 'WHERE (DATE '2009-12-31' - DataDate) > 18' compare days The 'WHERE (DATE '2009-12-31' - DataDate) > INTERVAL '18' MONTH' raise an error What is the right syntax? Thanks Sorin |
Sat, Nov 21 2009 7:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sorin
select _Invoiced, _invoiced - interval '18' month from invoices where (_invoiced - interval '18' month) > date '2006-04-08' Roy Lambert |
Sun, Nov 22 2009 10:32 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sorin,
<< I try to create a sql statement where the result are filter by months difference. The 'WHERE (DATE '2009-12-31' - DataDate) > 18' compare days The 'WHERE (DATE '2009-12-31' - DataDate) > INTERVAL '18' MONTH' raise an error >> Use this: SELECT * FROM MyTable WHERE (DATE '2009-12-31' - DataDate) MONTH > INTERVAL '18' MONTH -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |