如何在neo4j中存储时间数据类型? [英] How to store time data type in neo4j?

问题描述

我创建了一些具有一定价值的用户节点:

I created some user nodes with some value-time:

CREATE (u1:User {name:'user 1', pickUpTime:'10:10', dropOffTime:'10:35'})

我想知道什么是存储时间的好方法(格式)，因为当我执行这种查询时

I wonder what is a good way (format) to store time, because when i do this kind of queries

MATCH (u:User) RETURN u.name AS name, u.pickUpTime AS pickTime Order by pickTime desc

我得到了这个结果

name    pickTime
user 3  9:30
user 2  10:20
user 1  10:10

我需要得到有序的结果:

And i need to get an ordered result:

 name   pickTime
 user 3  9:30
 user 1 10:10
 user 2 10:20

有什么建议吗?预先感谢

Any suggestions? Thanks in advance

推荐答案

两个注意事项:

1. 您应该使用HH:mm之类的格式，这意味着您需要将9:30指定为09:30.

1. You should use a format like HH:mm that means that you need to specify 9:30 as 09:30.

在前一种情况下，如果您想获得所需的订单，则需要指定"pickTime asc排序"，而不是desc

Also in the previous case you need to specify "order by pickTime asc" and not desc if you would like to obtain the order you desire

这篇关于如何在neo4j中存储时间数据类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！