Subject | Different date/time formats and parametrized queries |
---|---|
Author | Thomas Steinmaurer |
Post date | 2003-03-06T17:55:50Z |
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.
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.