|Subject||RE: [firebird-support] Re: Time format|
> > How can I define format to hh:mm ?Thanks Svein, I'll try it.
> I don't think you can, but you could try to
> EXTRACT(HOUR FROM <TimeVariable>) and
> EXTRACT(MINUTE FROM <TimeVariable>)
> and combine them in a before insert trigger, hopefully making the
> seconds always end up as 00.
> By the way, never hijack a thread in this list like you did (you choseSorry, I'll be more carefull in future.
> reply to Lee's post and simply changed the subject). This means that
> some people will never actually read your mail, whereas others who
> view the mail threaded will see your mail intertwined with the SQL
> Help thread (hence, I chose to start a new thread for this reply).