| Subject | Re: [firebird-support] Time Fields - Set to just hold hour and minute? |
|---|---|
| Author | Lester Caine |
| Post date | 2004-12-29T09:43:07Z |
ra8009 wrote:
exclude seconds data for some reason you may want to add a trigger that
EXTRACT's the hour and minute and builds a new value from that. Then you
can look for records with matching 'times', but it is probably easier to
use BETWEEN HH:MM:00 AND HH:MM:59 and not worry about the seconds.
In either case what you 'display' to the user is up to your back end
application.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> Can I alter the Time format, but not the TimeStamp format, so that itIf you want to limit what is stored in a particular database field to
> only holds the Hour and minute?
exclude seconds data for some reason you may want to add a trigger that
EXTRACT's the hour and minute and builds a new value from that. Then you
can look for records with matching 'times', but it is probably easier to
use BETWEEN HH:MM:00 AND HH:MM:59 and not worry about the seconds.
In either case what you 'display' to the user is up to your back end
application.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services