Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 10 of 12 total |
SQL |
Fri, Oct 17 2008 8:21 AM | Permanent Link |
"Norbert Stellberg" | Hello,
how I must set a SQL statement for a date between 2 dates: SELECT * FROM "AuftragInhalt" AuftragInhalt WHERE (AuftragInhalt.RECHNUNGSDATE >1.1.1997) AND (AuftragInhalt.RECHNUNGSDATE <1.1.2000) with best regards Norbert |
Fri, Oct 17 2008 8:54 AM | Permanent Link |
"Robert" | "Norbert Stellberg" <Stellberg@Stellberg.de> wrote in message news:C9A5C75A-31E2-484A-B8F6-6F3F1C2A3AD4@news.elevatesoft.com... > Hello, > > how I must set a SQL statement for a date between 2 dates: > Use the format "YYYY-MM-DD" as in "1997-01-01" Robert > SELECT * FROM "AuftragInhalt" AuftragInhalt > WHERE (AuftragInhalt.RECHNUNGSDATE >1.1.1997) > AND (AuftragInhalt.RECHNUNGSDATE <1.1.2000) > > with best regards > Norbert |
Fri, Oct 17 2008 9:03 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Norbert
You didn't say which version of DBISAM so I'll assume v4 which wants the dates in ansi form (ie YYYY-MM-DD) >SELECT * FROM "AuftragInhalt" AuftragInhalt >WHERE (AuftragInhalt.RECHNUNGSDATE >1.1.1997) >AND (AuftragInhalt.RECHNUNGSDATE <1.1.2000) would be SELECT * FROM "AuftragInhalt" AuftragInhalt WHERE AuftragInhalt.RECHNUNGSDATE BETWEEN('1997-01-01' AND '2000-01-01') Roy Lambert [Team Elevate] |
Fri, Oct 17 2008 9:38 AM | Permanent Link |
"Norbert Stellberg" | Hello,
> SELECT * FROM "AuftragInhalt" AuftragInhalt > WHERE > AuftragInhalt.RECHNUNGSDATE BETWEEN('1997-01-01' AND '2000-01-01') thanks. But here comes an error: DBIsamerror 11949 SQL Parsing error Missing AND in SELECT SQL STATEMENT at line 4 column1 with best regards Norbert |
Fri, Oct 17 2008 9:42 AM | Permanent Link |
"Robert" | double quote
R "Norbert Stellberg" <Stellberg@Stellberg.de> wrote in message news:842F8AC1-7E94-4C90-81D7-1D839B01959A@news.elevatesoft.com... > Hello, > >> SELECT * FROM "AuftragInhalt" AuftragInhalt >> WHERE >> AuftragInhalt.RECHNUNGSDATE BETWEEN('1997-01-01' AND '2000-01-01') > > thanks. > But here comes an error: > DBIsamerror 11949 SQL Parsing error Missing AND in SELECT SQL STATEMENT > at line 4 column1 > > with best regards > Norbert |
Fri, Oct 17 2008 9:46 AM | Permanent Link |
"Norbert Stellberg" | Hello,
> double quote Sorry, what do you mean ? with best regards Norbert |
Fri, Oct 17 2008 10:45 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Norbert
please post the whole statement Roy Lambert [Team Elevate] |
Fri, Oct 17 2008 11:02 AM | Permanent Link |
"Robert" | "Norbert Stellberg" <Stellberg@Stellberg.de> wrote in message news:BF237F2F-997E-4C53-8192-9A5D0599B07B@news.elevatesoft.com... > Hello, > >> double quote > > Sorry, what do you mean ? BETWEEN "1999-01-01" AND "2008-01-01". Delimit the dates with double quotes. Robert |
Fri, Oct 17 2008 11:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Robert
You're right, I'd forgotten that. Roy Lambert |
Fri, Oct 17 2008 2:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy & Norbert,
Actually, it should be: SELECT * FROM "AuftragInhalt" AuftragInhalt WHERE AuftragInhalt.RECHNUNGSDATE BETWEEN '1997-01-01' AND '2000-01-01' No parentheses. -- Tim Young Elevate Software www.elevatesoft.com |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |