> I'm curious how you managed to get the timestamps if you didn't

want

> them. The datapump should have given you the ability to cast the
> timestamps to date and store them how you needed them...erm, unless

you ARE

> in dialect 1, and DID ask for DATE - 'cause the DATE type in

dialect 1 is a

> timestamp.
>
> /hb

As I said, I migrated my DB from MSSQL2000. MSSQL 2000 does not have
DATE type, only datetime, and those fields were datetime. Now, using
Firebird, I want those fields of type DATE.

Can you, please, give me some advices about firebird.
I am not beginer, I am using Interbase since `97. But, since I am
planning to use Firebird in one really BIG project (est. 15-18 gig of
data per year), one table with images stored in blobs (~40kb image
size). I would like to use Firebird on linux box (SUSE Enterprise
Server 8), dual P4 2.8G 2 Gig RAM.
I think that would be the best to go with classic version, not
superserver. What do you think? What else I should know since this is
going to be very big db?

Best regards
Fikret Hasovic
TAMP R&D Team