OpenEuphoria

Re: ODBC

• Posted by George Walters <gwalters at sc.rr.com> Sep 29, 2003
• 543 views

Thanks for all the replies. I guess I'll have to encode going in and decode
coming out....It's a little strange that a DB would store dates as a string
since you cannot do arithmetic on a string, although I guess you can use
greater/less than in comparisons for date ranges.

george

----- Original Message -----
From: "George Walters" <gwalters at sc.rr.com>
To: "EUforum" <EUforum at topica.com>
Subject: ODBC


>
>
> I'm setting up to try and use Matt's ODBC and connect to MySQL for a data
> base. In reviewing what I need to do I've found a point of confusion in
how
> I've been handeling dates and how MySQL handle's dates. I've been using a
> "sub sequence" in my record when using EUDB. as below.
>
> {a,b,c,{2003,09,29},e,f.....}
>
> this is quite convenient for dates to use the DateTime library (from user
> contributions) of functions I found in the archives. The problem is that
> MySQL uses yyy-mm-dd format. Is anyone doing this or has a suggestion on
> what happens when this is sent to MySQL. Hopefully there is a solution or
a
> better way to solve this issue.
>
> thanks.
>
> george
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>