--- In firebird-support@yahoogroups.com, "ra8009" <ra8009@...> wrote:

>
> From an application, I'm trying to submit a query for a time in the
> format '02: 00 :00 PM'. Is there a way for this to work without
> converting the time to '14:00:00'?
>

Date and time formatting is extremely variable because it often depends
on the way the OS is configured, although dates are worse than times
because a valid date could potentially be incorrectly interpreted.
Paramatised queries can be used to take away this headache entirely.
What development environment and connection components are you working
with?

Adam