Hi Nico,

> Thanks for the response. Are you sure about Timestamp in IB 5.6,
> dialect 1 ? Because most of our customers are running under dialect
> 1 still.

In IB < 6, it's called DATE, in IB 6, dialect 3, it's called TIMESTAMP.

In dialect 3, DATE holds date only while TIME holds time only.
TIMESTAMP holds both.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> Best regards, Nico
>
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> > Hi Nico,
> >
> > > After migrating from IB 5.6 to FB 1.5, we changed the dialect to
> 3.
> > > Because there is no common datatype in IB and FB to hold Date and
> > > Time in 1 field,
> >
> > Yes there is - its called TIMESTAMP.
> >
> > >we want to switch back to dialect 1, so we can use
> > > DATE datatype again. Is this possible, because after changing
> with
> > > GFIX, we get BIGINT errors.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - developer tool for InterBase, Firebird, MySQL
> & MS SQL
> > Server.
> > Upscene Productions
> > http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>