> > > i have a problem in select query.
> > > When i issue the following select query
> > >
> > > "select DT_START,DT_END,DT_START || ' - ' || DT_END SHAM from
> > > year_setup"
> > >
> > > iam getting the following result
> > > dt_satrt=01.04.2005
> > > dt_end=31.03.2006
> > > SHAM=2005.04.01 - 2006.03.31
> > >
> > > (* Dates are stored in dd.mm.yyyy format in the year_setup table)
> > >
> > > But i want to get the third field in the same format as the first two.
> > > How can i do?
> >
> > I can not explain why the two interpretations of the same field are
> > different,

hang on - I think h's actually storing the dates as preformatted strings -
is this correct? i.e. they are not stored as data type DATE. So you will
need to cast them to date if you want to do date arithmetic.

Alan

>
> I can :-)
>
> dt_start and dt_end are transported to the client as "date", indeed,
> they are formatted by the client.
>