mongoTemplate andExpression的一些使用方式

1 用于类似function(val1…val2)的函数,参数为数值/数组

//增加8小时时区
//{$dayOfWeek : { $add : [$createTime,  28800000]} }
project().andExpression("dayOfWeek(add(createTime," + 8 * 60 * 60 * 1000 + "))").as("day")
project().andExpression("dayOfWeek(add(createTime, [0]))", 8 * 60 * 60 * 1000).as("day") //等效于上条

2 直接写命令方式

 //增加8小时时区 

 //{ "$dateToString" : { "date" : "$ctime", "format" : "%Y-%m-%d %H:%M:%S", "timezone" : "+08:00" } }}   
 project().andExpression("{ $dateToString: {date: '$createTime', 
 format: '%Y-%m-%d %H:%M:%S', timezone: '+08:00'}}").as("day")  

 //存在数组时的写法 {val1, val2}  
 //{ "$dateToString" : { "date" : { "$add" : ["$ctime", 28800000] }, "format" : "%Y-%m-%d %H:%M:%S" } } }
 project().andExpression("{ $dateToString: {date: { $add: {'$ctime', [0]} }, format: '%Y-%m-%d %H:%M:%S'}}", 28800000).as("day")
 project().andExpression("{ $dateToString: {date: { $add: {'$ctime', 28800000} }, format: '%Y-%m-%d %H:%M:%S'}}").as("day") 
 //等效于上条