Subject | Re: Date compare in firebird |
---|---|
Author | redtneen |
Post date | 2007-08-16T13:43:49Z |
--- In firebird-support@yahoogroups.com, "ibrahim
bulut" <i.bulut@...> wrote:
but my problem i that this code generated in run time
and i can't in easy way to know dates to compare so i can change them
to parameters
i think the problem is that in every loop there is a converting from
string date to actual date for const dates(like '05/01/2006' ..)
any chance to made the server do this converting just once before
executing the block and manage these consts or any other soluation
bulut" <i.bulut@...> wrote:
>yes i tested it before and yes it's useful thanks to u.
> Did you try to change string dates to parameters for this block
>
> I have not tested but may be useful
>
but my problem i that this code generated in run time
and i can't in easy way to know dates to compare so i can change them
to parameters
i think the problem is that in every loop there is a converting from
string date to actual date for const dates(like '05/01/2006' ..)
any chance to made the server do this converting just once before
executing the block and manage these consts or any other soluation