In Delphi 6, Win XP SP2, I set the Regional Settings to Romania (in my case) and the default date setting is

'dd.mm.yyyy'

In D6 all my queries (Firebird, Interbase, BDE) are done in the same way :

ex.:
SELECT FROM mytable WHERE mydatefield > 'dd.mm.yyyy'


Tiberiu

----- Original Message -----
From: buppcpp
To: firebird-support@yahoogroups.com
Sent: Sunday, June 12, 2005 2:50 PM
Subject: [firebird-support] Re: Date problem in Firebird


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.






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net 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

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Discover Yahoo!
Have fun online with music videos, cool games, IM & more. Check it out!

[Non-text portions of this message have been removed]