[ Programing ]/Database
[MySQL] UNIX_TIMESTAMP / FROM_UNIXTIME
Mister_Q
2022. 11. 10. 09:53
-- 날짜 -> 시간 변환.
-- EX) 2022-07-01 10:50:59 -> 1656640259
UNIX_TIMESTAMP( [날짜] );
-- (TimeStamp)시간 -> 날짜 변환.
-- EX) 1656640259 -> 2022-07-01 10:50:59
FROM_UNIXTIME( [(TimeStamp)시간] );
