Subject | Re: [firebird-support] Re: Delphi and Firebird |
---|---|
Author | Martijn Tonies |
Post date | 2004-11-03T18:51:56Z |
Hi,
while with "." you should use DD.MM.YYYY
formats.
Mind you, the tool you're using to display the date as the
result of a SELECT query probably uses the OS settings.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> > > At the moment I query a table between date with the use of parameters.Well, with parameters you're avoiding that issue :-)
> > >
> > > as in
> > >
> > > select *
> > > from x
> > > where A = :MyDate
> > >
> > > With the use of parameters, you just pas :MyDate as a Date and you
> > > don't have to worry about the right formatting of the Date.
> > >
> > > Now, because of circumstances, I would like to not use parameters, but
> > > I would like to create the sql code on the fly, as in
> > >
> > > select *
> > > from x
> > > where A = '2003/01/20'
> > >
> > > Is there a way to know the exact format to be used?
> >
> > The US format:
> > MM/DD/YYYY
> >
> > But: why?
>
> In the new way I need to write the query as a string. So I need to
> convert all the values into strings.
> Isn't is so that when you use the wrong dateformat, you get not result
> from the query?
> does firebird gives the same result inNo. I believe when using the "/", you should use MM/DD/YYYY
>
> select *
> from x
> where a = '08/12/2004'
>
> and
>
> select *
> from x
> where a = '08.12.2004'
while with "." you should use DD.MM.YYYY
> or?This won't work.
>
> select *
> from x
> where a = '20/12/2004' (european notation)
> I thought that the firebird format was based on the OS on whichIt's unaffected by OS settings - it has its own set of available
> firebird is running. Or is it always the US Format?
formats.
Mind you, the tool you're using to display the date as the
result of a SELECT query probably uses the OS settings.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com