Lose the 'AM'. I think it's expecting:
"mm/dd/yyyy hh:mm:ss", with the time part being a 24-hour part, at
least that works for me.

--- In firebird-support@yahoogroups.com, "Bob Murdoch"
<mailgroups@m...> wrote:

> I'm trying to concatenate two columns that contain varchar
> information, one for date and one for time.
>
> I can't seem to figure out what FB 1.5 will accept for automatic
> conversion to a DATE data type (dialect 1).
>
> Give a varchar of '5/1/2005' and '10:00 AM', how can I concatenate the
> two into a DATE column?
>
> A simple '5/1/2005' || ' ' || '10:00 AM' does not work (conversion
> error).
>
> tia,
>
> Bob M..