I'm using OpenIB 6.0.1.6! I have to map some database items to caertain time
constraints! i.e. I have to check if a given event (the dailly kind of
event, not progrmming event ) inserted by the user is in acordance to a time
schedule previuslly definid in the database! The problem is that the Date
data type stored also the day! How can I cast or something so that my SQL
Querys and StoredProcs only 'see' the time and do not consider the day!

thanks

Miguel

Ever thought of a dialect 3 database - you have TIME, TIMESTAMP
and DATE column types.

--

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

Thanks for the anwser!

We used to work in paradox! When we started pumping from paradox to IB the
pumper had some problems with dialect 3! Then though I had read about the
advantages of dialect 3, and working on a narrow schedule we adopted dialect
1!

Two question derived from your anwser:

#1
What are the potencial problems of starting to use dialect 3 on a
database/application that has been in a 6 month development cicle and was
designed with dialect 1!

#2
If I for some reason chose not to adopt dialect 3 is there a workarround for
this problem!

Thanks Martjin

"Martijn Tonies" <m.tonies@upscene!nospam!.com> escreveu na mensagem
news:3e92b1f6@newsgroups.borland.com...