OpenEuphoria

RE: ODBC

• Posted by Jonas Temple <jtemple at yhti.net> Sep 29, 2003
• 453 views

George,

In my experience with databases (mostly DB2) a date field is usually 
returned to the PC as a character string (i.e. "2003-09-29" so maybe in 
your case your example needs to be:

{a,b,c,"2003-09-29",e,f,....}

HTH,

Jonas
George Walters wrote:
> 
> 
> 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
> 
>