How to change Oracle session parameter value like NLS_TIMESTAMP_FORMAT

[iverycd]

Hi,Thank you for the great project! I am new for this project and my code connect to oracle,i need to change Oracle NLS_DATE_FORMAT parameter like below:

alter session set NLS_TIMESTAMP_FORMAT= 'YYYY-MM-DD HH:MI:SS.FF';

How can i using go-ora change this parameter value,i did not find this example in your project

[sijms]

Hi @iverycd this is the code to call alter session and change this parameter

func main() {
conn, err := sql.Open("oracle", os.Getenv("DSN"))
    if err != nil {
        fmt.Println("connection error: ", err)
        return
    }
    defer func() {
        err = conn.Close()
        if err != nil {
            fmt.Println("error during conn close: ", err)
        }
    }()
    _, err = conn.Exec(`alter session set NLS_TIMESTAMP_FORMAT= 'YYYY-MM-DD HH:MI:SS.FF'`)
    if err != nil {
        fmt.Println("execute error: ", err)
        return
    }
}

[iverycd]

Hi @iverycd this is the code to call alter session and change this parameter

func main() {
conn, err := sql.Open("oracle", os.Getenv("DSN"))
  if err != nil {
      fmt.Println("connection error: ", err)
      return
  }
  defer func() {
      err = conn.Close()
      if err != nil {
          fmt.Println("error during conn close: ", err)
      }
  }()
  _, err = conn.Exec(`alter session set NLS_TIMESTAMP_FORMAT= 'YYYY-MM-DD HH:MI:SS.FF'`)
  if err != nil {
      fmt.Println("execute error: ", err)
      return
  }
}

Thanks,it works for me