Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
days from day |
Wed, Oct 24 2007 6:32 AM | Permanent Link |
"Harry de Boer" | LS
How do I write the following (dbisam) queryline in EDB: AND (contracten.Datum + 14 between date'2006-01-05' and date'2006-12-31') Regards, Harry |
Wed, Oct 24 2007 7:37 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
Quick cheat AND (contracten.Datum between date'2006-01-19' and date'2007-01-13') Roy Lambert |
Wed, Oct 24 2007 8:10 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
Much experimentation, masses of error and some reading of the OLH later select * from transactions where (_Date + INTERVAL '14' DAY) between date'2007-04-20' and date'2007-05-30' Roy Lambert |
Wed, Oct 24 2007 8:13 AM | Permanent Link |
"Harry de Boer" | Roy,
Nice one The SQL string is build from user input (here 14 days), and could change. The syntax worked in dbIsam, but not in EDB. So the question remains Regards, Harry "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht news:AC124461-4A67-4187-8C03-5BC8A49AA31E@news.elevatesoft.com... > Harry > > Quick cheat > > AND (contracten.Datum between date'2006-01-19' and date'2007-01-13') > > > Roy Lambert |
Wed, Oct 24 2007 8:14 AM | Permanent Link |
"Harry de Boer" | Roy,
Thanks! Regards, Harry "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht news:B27A8944-2444-4102-AC84-FB2229011390@news.elevatesoft.com... > Harry > > > Much experimentation, masses of error and some reading of the OLH later > > select * from transactions where (_Date + INTERVAL '14' DAY) > between date'2007-04-20' and date'2007-05-30' > > > Roy Lambert > |
Wed, Oct 24 2007 9:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
I don't know if it is what the standard says, and I know it has more power than the old style datefield + 14 but its a lot less programmer friendly. All I have to do now is remember it for when I need it Roy Lambert |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |