mysql查询时间日期转换

转换示例如下

1
2
3
4
5
6
7
8
9
10
SELECT
	order_id orderId,
	REPLACE(REPLACE(FROM_UNIXTIME(order_time/1000,'%Y%m%D%H:%i'),'th',''),':','') AS orderTime,
	"202102" AS orderMonth 
FROM
	mall_order_sku_202102 as t1
WHERE
	sku_id = 10023919984358 
	AND order_time >= 1614355200000 
	AND order_time < 1614441600000

如果本文对你有所帮助，请赏我1个铜板买喵粮自己吃，您的支持是我最大的动力！！！