The other date problem that I have run across is the use of a
regular date syntax within in SQL statement.

ie.

SELECT FROM mytable WHERE mydatefield > 1/01/2004;

This results in this error: conversion error from string "0".

Is there a way to get regular date to work in 1.5 WITHOUT casting or
some function use.

I'm converting from sereval other databases and this type of SQL
statement is standard.

--- In firebird-support@yahoogroups.com, "shaamim_ply"
<shaamim_ply@y...> wrote:

> > So, you have two choises.
> > So, is there a reason to push that last field at all?
> > Maybe you should tell us, why you think you need to produce this
> on the
> > server, and we can help you with your real problem, instead of
> discussing
> > simptoms of it...
> >
> > Regards,
> > Steffen
>
>
> Actually,I am passing the select query to my custom search grid.It
> is designed in that way(accepting query as the parameter)& it will
> show the result of the query .
>
> eg:
> SQL=select dt_start,dt_end,dt_start||' - '||dt_end SHAM from
> year_setup
> (*dt_start,dt_end are date types)
>
> when i pass the "SQL" to my custom search grid,it will show the
> records. There is no formatting in my grid,so I should format it

in

> the query itself. The above query worked well in oracle,but in
> firebird the concatenation making prblms.
> So if the only way is to use any UDF,pls give the necesary codes

for

> that.