--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 05:11 PM 21/07/2006, you wrote:
> >Hope someone can assist:
> >
> >I am using MSQery to get data into excel from firebird 1.5 (using
> >firebird ODBC 2.0).
> >
> >I can enter a fixed date in MSquery and the data is returned. If I
> >use a variable then the following error is returned:
> >
> >Dynamic SQL Error
> >SQL error code = -303
> >Conversion error from string "[date/time]"
> >
> >where [date/time] is the date entered followed by 00:00:00
> >
> >eg: entering 21/07/2006 as the variable returns the string "2006-07-
> >21 00:00:00"
>
> Yup, Firebird doesn't recognise a date literal in the format
> "dd/mm/yyyy" - it always interprets that format as "mm/dd/yyyy" and
> of course there is no month 21, hence the exception!
>
> Find a way to decode the date into a format that is accepted. Here

are some:

>
> dd-Mmm-yyyy
> dd.mm.yyyy
> yyyymmdd
> yyyy-mm-dd
>
> Even dd Mmm yyyy should work ok.
>
> ./heLen
>
>

Thanks for the thought - have already tried all these. Some return
"Syntax Error in Date" (such as yyyymmdd, or dd-Mmm-yyyy) and others
return the good old Error -303 (such as dd.mm.yyyy).

The problem seems to be in MSQuery as it is MSQuery that returns the
error, but I don't know if it is just MSQuery or the ODBC driver.

Any other ideas?

Thanks,
John

> >Does anyone have a fix for this?
> >
> >Thanks,
> >John
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit http://www.firebirdsql.org and click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
>