OpenEuphoria

Question about ODBC/SQL server

• Posted by Henri.Goffin at sbs.be Sep 05, 2001
• 408 views

Hello everybody

I'm using Matt Lewis's ODBC wrap and it works fine. My problem is that I
retrieve data from a MS SQL Server that contain a date-time field (quite usual in
a database application). The representation of such a field is returned as a
Euphora sequence that is somewhat unintelligible.

For example date-time 08/20/2001 06:30:10 is returned as:
{209,7,8,0,20,0,6,0,30,0,10,0,0,0,0,0}

Clearly month is s[3], day is s[5], hour is s[7], minutes is s[9] and seconds is
s[11], but what about the rest? Where is the year? And how do you interpret the
other atoms?

Any idea (or doc)?

Henri Goffin