dpvr49226 2019-07-17 17:22
浏览 62

如何解释这些时间戳

I have different values in Google datastore column TS. The column type is string. Here are bunch of values

1994-11-04T13:15:30Z    
1994-11-06T13:15:30Z    
1994-11-05T08:15:30-05:00   
1994-11-07T08:15:30-05:00

Now these values are in 2 different formats. The one with Z represent the timestamp in UTC timezone. However, the one with the offset is representing local timezone (am I correct here?)

Now the problem is that the query that we are making in our project does ordering based on this column i.e.,

query := datastore.NewQuery(myEntityType).
    Namespace(myNameSpace.String()).
    Order("-TS")
rows := make([]domain.datastore.rows, 0)
_, err := r.client.GetAll(ctx, query, rows)

There client is cloud.google.com/go/datastore object.

I am unable to test this in my local but in prod, the end user are seeing these things out of order. However, if I go to datastore UI, and sort values by clicking on TS column, they order just fine. Which is confusing me that if the error was on sorting, shouldn't the error be there on UI as well?

So I am not sure how to fix this bug. Should I convert Google Datastore column to Timestamp (can we do so?). Or should I fix the code to persist consistently?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 Python安装cvxpy库出问题
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
    • ¥15 python天天向上类似问题,但没有清零
    • ¥30 3天&7天&&15天&销量如何统计同一行
    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 C#调用python代码(python带有库)
    • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
    • ¥15 活动选择题。最多可以参加几个项目?
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题