Skip to content

Panic when using some date functions

This triggers a panic:

package main

import (
        "database/sql"

        _ "modernc.org/sqlite"
)

func main() {
        dbh, err := sql.Open("sqlite", "db.db")
        if err != nil {
                panic(err)
        }

        if _, err := dbh.Exec(`
        SELECT DATE("now", "localtime")
        `); err != nil {
                panic(err)
        }
}

And yet this works:

echo 'SELECT DATE("now", "localtime")' | sqlite3