Hello Jerry,

>You bring up a good point, Helen, about the time going past the 24 hour
>mark. The query that I am running was originally written with timestamps
>and it worked fine, I decided to play with the time data type for
>simplicity
>but I do need to get into the next day a few hours so I will be going back
>to what I originally was doing. I thought this might be a place to learn
>about the Time data type and it looked like it would make the coding
>cleaner
>and easier.

If you want to store a "duration", then TIME just won't cut it, as it
means "time of day". TIMESTAMP is slightly better, but still, it's
"time of day and date on a calendar", a duration needs its own
datatype. Firebird does not yet have such a thing, so you can store
integers (to stored "seconds past since" or something).


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com