Subject Different date/time formats and parametrized queries
Author Thomas Steinmaurer
Hello,

I have to deal with dates/times stored in a VARCHAR column
in possible different IB/FB valid date/time formats.

For example:

2003-01-02
2002-12-11 13:12:14.0000
1-JAN-2003
06.12.2003

...

What I want to do achieve now is to take this string value
and insert it via a parametrized DSQL statement into an
according FB/IB column of type DATE (dialect 1) resp.
TIMESTAMP (dialect 3).

Is there a reliable IBO way to do that in the client app
independent of any Windows regional settings (e.g. when
using the TIB_Column.AsDate... getter methods)?

Thanks for any help.

Regards,
Thomas.