> > How can I define format to hh:mm ?
>
> 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.

Thanks Svein, I'll try it.

> By the way, never hijack a thread in this list like you did (you chose
> 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).

Sorry, I'll be more carefull in future.


Regards,
Primoz