DateTime Fields Always return "2118-03-XX XX:XX:XX.XXXXXXXXXXXX UTC"

[csntgao]

The code is as following:

============================
for rows.Next() {
        var date time.Time
        rows.Scan(&date)
        fmt.Println(date)
    }
============================

The Result is as followiing:

2118-03-04 04:28:28.545076635 +0000 UTC

2118-03-04 04:28:28.381231586 +0000 UTC

2118-03-04 04:28:27.996275258 +0000 UTC

2118-03-04 04:28:27.826067295 +0000 UTC

2118-03-04 04:28:27.340895064 +0000 UTC

2118-03-04 04:28:27.242269889 +0000 UTC

2118-03-04 04:28:27.041838082 +0000 UTC

2118-03-04 04:28:26.865267204 +0000 UTC

2118-03-04 04:28:26.209887009 +0000 UTC

2118-03-04 04:28:25.976049901 +0000 UTC

But in fact ,the Datas in My Database(MSQL2000 or MSSQL2008) are :

2011-02-14 21:25:46.000
2011-02-14 21:24:03.000
2011-02-14 21:20:01.000
2011-02-14 21:18:14.000
2011-02-14 21:13:09.000
2011-02-14 21:12:07.000
2011-02-14 21:10:01.000
2011-02-14 21:08:10.000
2011-02-14 21:01:18.000
2011-02-14 20:58:51.000

Would Please tell me WHY? or What should I do to correct the errors? Thank You.

[mattn]

@andybalholm Can you handle this issue?

[csntgao]

I'm Waiting and waiting while the flowers have WILTED!

[andybalholm]

Does this patch work?

diff --git a/adodb.go b/adodb.go index 6727f25..bef8453 100644 --- a/adodb.go +++ b/adodb.go @@ -357,11 +357,16 @@ func (rc *AdodbRows) Next(dest []driver.Value) error { case 132: // ADUSERDEFINED dest[i] = uintptr(val.Val) case 133: // ADDBDATE

• dest[i] = time.Unix(0, val.Val).UTC()
• // see http://blogs.msdn.com/b/ericlippert/archive/2003/09/16/eric-s-complete-guide-to-vt-date.aspx
• d := math.Float64frombits(uint64(val.Val))
• dest[i] = time.Date(1899, 12, 30+int(d), 0, 0, 0, 0, time.Local) case 134: // ADDBTIME
• dest[i] = time.Unix(0, val.Val).UTC()
• t := math.Float64frombits(uint64(val.Val))
• dest[i] = time.Date(0, 1, 1, 0, 0, int(t*86400), 0, time.Local) case 135: // ADDBTIMESTAMP
• dest[i] = time.Unix(0, val.Val).UTC()
• d, t := math.Modf(math.Float64frombits(uint64(val.Val)))
• t = math.Abs(t)
• dest[i] = time.Date(1899, 12, 30+int(d), 0, 0, int(t*86400), 0, time.Local) case 136: // ADCHAPTER dest[i] = val.ToString() case 200: // ADVARCHAR

[csntgao]

It's Right,thank andybalholm!

[mattn]

Ok, I'll include it.