关于SQL日期

select
    ct.user_id,
    gt.room_id,
    gt.room_type,
    datediff(ct.checkout_time,ct.checkin_time) days
# datediff(A,B)表示「从 B 到 A」跨越的整天数
from
    checkin_tb ct
    inner join guestroom_tb gt on ct.room_id = gt.room_id # left join也行
where
    ct.checkin_time >= "2022-06-12"
	# sql日期格式'2022-06-12 00:00:00'
    and datediff(ct.checkout_time,ct.checkin_time) >= 2
order by
    4 asc,
    2 asc,
    1 desc