Subject Re: Dialect 3 Time Field Query
Author Adam
--- In, "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