![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
![]() |
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 ![]() | 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 ![]() | 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 ![]() | 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 Monday, June 17, 2024 at 07:11 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |