Subject Re: [ib-support] Type Casting
Author German Terrazas
do not worry, i will send a check asap.


On Fri, 7 Mar 2003, Helen Borrie wrote:

>
> Please send your support questions to the list. I charge MONEY for private
> tuition.
>
> At 09:14 AM 7/03/2003 -0300, German Terrazas wrote:
> >helen,
> >
> >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.
>
> heLen
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>