I think you will need to write a custom routine to handle this requirement.
You might check some of the free Delphi component sites for libraries that
have date processing routines.

That's an interesting idea to incorporate this into the getter of the AsDate
getter method. I'm open to suggestions on how this logic could be hooked in
and made use of for your flexibility.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Thursday, March 06, 2003 10:55 AM
Subject: [IBO] Different date/time formats and parametrized queries


> 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.