我試圖更新表格，但我得到了這個(gè)錯(cuò)誤：錯(cuò)誤 400：時(shí)間戳無效：“2021-03-02 05：34：51.161346 +0000 UTC”，無效查詢]）如何將其轉(zhuǎn)換為時(shí)間戳？代碼如下：ctx := context.Background()client, err := bigquery.NewClient(ctx, projectID)if err != nil { return fmt.Errorf("bigquery.NewClient: %v", err)}defer client.Close()q := client.Query("UPDATE myTable SET name = "John Doe", date_updated = TIMESTAMP("2021-03-02 05:34:51.161346 +0000 UTC") WHERE id = 10"
1 回答
慕的地6264312
TA貢獻(xiàn)1817條經(jīng)驗(yàn) 獲得超6個(gè)贊
嘗試
q := client.Query("UPDATE myTable SET name = 'John Doe', date_updated = TIMESTAMP('2021-03-02 05:34:51.161346') WHERE id = 10"要設(shè)置時(shí)區(qū)使用：+00
q := client.Query("UPDATE myTable SET name = 'John Doe', date_updated = TIMESTAMP('2021-03-02 05:34:51.161346+00') WHERE id = 10"- 1 回答
- 0 關(guān)注
- 111 瀏覽
添加回答
舉報(bào)
0/150
提交
取消