MySQL | FROM_UNIXTIME() 함수 활용
페이지 정보
작성자 100K5 작성일12-04-27 09:41 조회41,401회 댓글0건관련링크
본문
이 함수는 유닉스 타임시간을 YYYY-MM-DD HH:MM:SS(또는 YYYYMMDDHHMMSS.uuuuuu) 로 반환합니다.
예제
SELECT
// 테이블생성
CREATE TABLE `test_table` ( `regdate` INT NOT NULL ) TYPE = MYISAM ;
// 데이타 삽입
INSERT INTO `test_table` ( `regdate` ) VALUES ('1220799600 ');
INSERT INTO `test_table` ( `regdate` ) VALUES (unix_timestamp());
CREATE TABLE `test_table` ( `regdate` INT NOT NULL ) TYPE = MYISAM ;
// 데이타 삽입
INSERT INTO `test_table` ( `regdate` ) VALUES ('1220799600 ');
INSERT INTO `test_table` ( `regdate` ) VALUES (unix_timestamp());
SELECT FROM_UNIXTIME(unix_timestamp);
SELECT FROM_UNIXTIME(unix_timestamp, format);
SELECT FROM_UNIXTIME(unix_timestamp, format);
예제
// 년월일 시분초
SELECT
DATE_FORMAT(FROM_UNIXTIME(regdate)) regdate
FROM
test_table
-> 2012-04-27 09:45:10
SELECT
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y-%m-%d %H:%i:%s') regdate
FROM
test_table
// 검색시
SELECT
SELECT
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y-%m-%d %H:%i:%s') regdate
FROM
FROM
test_table
WHERE
WHERE
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y%m%d') = DATE_FORMAT(now( ), '%Y%m%d')
// BETWEEN 검색
SELECT
SELECT
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y-%m-%d %H:%i:%s') regdate
FROM
FROM
test_table
WHERE
WHERE
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y%m%d')
BETWEEN
BETWEEN
DATE_FORMAT(DATE_ADD(now( ), INTERVAL '-3' DAY), '%Y%m%d')
AND DATE_FORMAT(DATE_ADD(now( ), INTERVAL '3' DAY), '%Y%m%d')
AND DATE_FORMAT(DATE_ADD(now( ), INTERVAL '3' DAY), '%Y%m%d')
// BETWEEN 검색
SELECT
SELECT
DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y-%m-%d %H:%i:%s') regdate
FROM
FROM
test_table
WHERE
WHERE
DATE_ADD(FROM_UNIXTIME(regdate), INTERVAL '3' DAY), '%Y%m%d')
BETWEEN
BETWEEN
DATE_FORMAT(DATE_ADD(now( ), INTERVAL '-3' DAY) , '%Y%m%d')
AND DATE_FORMAT(DATE_ADD(now( ), INTERVAL '3' DAY) , '%Y%m%d')
AND DATE_FORMAT(DATE_ADD(now( ), INTERVAL '3' DAY) , '%Y%m%d')
댓글목록
등록된 댓글이 없습니다.