Subject Re: [ib-support] Type Casting
Author Helen Borrie
Please send your support questions to the list. I charge MONEY for private

At 09:14 AM 7/03/2003 -0300, German Terrazas wrote:
>At windows settings I have date format as DD/MM/YYYY and after query it
>returns YYYY-MM-DD
>If I set date format to MM/DD/YYYY, the query returns YYYY-MM-DD either.
>Type cast works in the same way. So, whats wrong ?

It looks OK to me. I don't think it obeys Windows settings...for example,
I have my Windows short date as d/MM/yyyy but I get 07-MAR-2003 returned
for today's date...the database has character set NONE.

What tool are you using? What character set?
Just curious - why do you need to get the date as a string? If you bring
it into your application and cast it as a date type, you can then use a
Windows tool to format it for display.