OpenEuphoria

Re: ODBC

• Posted by "C. K. Lester" <euphoric at cklester.com> Sep 29, 2003
• 516 views

> 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

Format your data with this:

    sprintf("\"%04d-%02d-%02d\"", { year,month,day } )

Then give it to MySQL. I don't know if you'll need the quotes... I would
expect so to send a string.

This way you can keep all your current algorithms.