🚀 go-pugleaf

adalberto baldini wrote:

> Magnus wrote:
> 
> > adalberto baldini wrote:
> > 
> > > I have set my computer with date in format dd/mm/yyyy and dd/mm/yy
> > 
> > The server doesn't know your date format.
> > 
> > > I run a query
> > > select  * from CURCY_CHG_DATE('ED', '01/10/2006')
> > > 
> > > and param date is processed in format mm/dd/yy
> > > 
> > > Any suggestion ?
> > 
> > 
> > Yes, either use
> > a) parameters   
> 
> ? in the same format as below ?
> 
> > b) or one of Interbase's date formats (for example yyyy-mm-dd or
> > mm/dd/yyyy)
> 
> Now I am a little confused : what is value recorded in DB ????
> 
> Using IBConsole
> 
> I enter in a date colum  04/24/2006 but I got error 'date is not
> valid ' , and 24/04/2006 is accepted.
> 
> In SQL if I run a query :
>  select * from curcy_chg_date('ED','24/04/2006')
> I get Error at line 1 - conversion error from string "24/04/06"
> and 04/24/2006 or 2006/04/24 are accepted.
> 
> Obs. Date returned by query are in format dd/mm/yyyy
> 
> Regards
> Adalberto Baldini

Hi Adalberto,

The IB Server expects the date format in English style. So in SQL you
have to use the format mm/dd/yyyy or mm/dd/yy. IBConsole uses your
regional settings in the data view and translate the date to the
required format.

--