ODBC Date Formats

For questions and postings not covered by the other forums
IanAFear
Posts: 1
Joined: Thu Sep 22, 2011 1:34 pm

ODBC Date Formats

Postby IanAFear » Thu Sep 22, 2011 1:56 pm

working with query tool and Jade ODBC to interigate a Greentree DB have been unable to figure out how to pass a date into the SQL where Clause
any Hints greatly appreciated

allistar
Posts: 156
Joined: Fri Aug 14, 2009 11:02 am
Location: Mount Maunganui, Tauranga

Re: ODBC Date Formats

Postby allistar » Thu Sep 22, 2011 11:21 pm

Try this:

WHERE SomeClass.someDate={d '2011-09-22'}

sangland
Posts: 1
Joined: Wed Aug 21, 2013 3:03 pm

Re: ODBC Date Formats

Postby sangland » Wed Aug 21, 2013 3:16 pm

Hi, does anyone know how to pass a date parameter into an ODBC query. Using using MS Query "?" prompts for a parameter:
1. eg WHERE SomeClass.someDate= ?
Parameter={d '2011-09-22'} (Gives Jade ODBC error - invalid parameter type)

2. eg WHERE SomeClass.someDate= {d ?} - (Gives Jade ODBC server error -Expecting 'characterStringLiteral'; found '?')
3. eg WHERE SomeClass.someDate= {?} - (Gives Jade ODBC server error -Expecting 'o d b c date time value'; found '?')


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 17 guests