OpenEuphoria

Re: ODBC dates

• Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Oct 25, 2004
• 491 views

George Walters wrote:
> 
> Matt, I suspect there's a difference between what mysql and EUdb return
> for a date field. I changed 1.3 convert date to
> 
> }}}
<eucode>
>     elsif dt = SQL_TYPE_DATE then
> 
>     		str = {str[2]*256+str[1], str[4]*256 +str[3], str[6]*256+str[5]}
> 
> 		return str
> </eucode>
{{{

> 
> and it started to work again...

Hmmm...that's interesting.  I think I originally tested it with Access,
and the SQL_TYPE_DATE came back as a string.  I just downloaded MySQL,
so I'll see if I can figure out a better way to do this.

Matt Lewis