Output of time.Time is to zero value about go-sqlite3 HOT 5 CLOSED

This looks like an issue with using GoLang RFC3339 / RFC3339Nano timestamps..?

from go-sqlite3.

I think, if the values will be possible to be nil, it should be used for string or another types. How do you think?

from go-sqlite3.

@mattn, I didn't quite understand, what do you mean? What should be used for string types?

We would really like to use this library over here, but we need dates to work correctly.

from go-sqlite3.

Ah, sorry. I was sleepy. You can use *time.Time instead of time.Time.

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/mattn/go-sqlite3"
    "log"
    "os"
    "time"
)

func main() {
    os.Remove("boooo.db")
    db, err := sql.Open("sqlite3", "boooo.db")
    if err != nil {
        log.Fatal("Failed to open database:", err)
    }
    defer db.Close()

    db.Exec(`create table foo (id integer, dt datetime);`)
    db.Exec(`insert into foo(id, dt) values(1, datetime('now'))`)
    db.Exec(`insert into foo(id, dt) values(2, null)`)
    rows, err := db.Query(`select id, dt from foo`)
    if err != nil {
        log.Fatal("Failed to call db.Query:", err)
    }
    defer rows.Close()
    for rows.Next() {
        var id int
        var dt *time.Time
        err = rows.Scan(&id, &dt)
        if err != nil {
            log.Fatal("Failed to db.Query:", err)
        }
        fmt.Println(id, dt)
    }
}

This dt should be datetime or nil. You can use string instead of it. This is not a spec of go-sqlite3. So, sorry about I can't fix this.

from go-sqlite3.

It turned out the problem was actually because the database being used was using this time format: 2014-05-21 12:55:40+00:00, which wasn't included in SQLiteTimestampFormats. I have added it and submitted a pull request.

from go-sqlite3.