mysql timestamp long_mybaits長整形long與時間戳mysql timestamp資料轉換

借用MySQL函數實作

long 轉 timestamp：FROM_UNIXTIME(long, [format])

示例：限制10位時間戳，13位不可以

FROM_UNIXTIME(1249488000)

或

FROM_UNIXTIME(1249488000, '%Y-%M-%d %H:%m:%s')

整合到mybatis leaveTime為long型

insert into

reserve_record(orderId, uname, phoneNumber, roomType, reserveTime, preFee, status, startTime, endTime)

values (#{orderId}, #{uname}, #{phoneNumber}, #{roomType}, NOW(), #{preFee}, 0,

FROM_UNIXTIME(#{signTime}), FROM_UNIXTIME(#{leaveTime}))

timestamp轉long：UNIX_TIMESTAMP

示例：

UNIX_TIMESTAMP('2020-07-11')

來源：https://www.cnblogs.com/iQXQZX/p/13284453.html