mysql unix_timestamp, 날짜형식

http://nosmoke.tistory.com/458
select unix_timestamp('2008-07-07');
->timestamp 형태로 출력

DATE_FORMAT(FROM_UNIXTIME(10021548),'%Y%m')
->날짜형식으로
-> FROM_UNIXTIME(10021548, '%Y%m') : 이런식으로 해도 되더라

http://phpschool.com/gnuboard4/bbs/board.php?bo_table=tipntech&wr_id=62911&page=1 // 테이블생성 CREATE TABLE `test` ( `regdate` INT NOT NULL ) TYPE = MYISAM ; // 데이타 삽입 INSERT INTO `test` ( `regdate` ) VALUES ('1220799600 '); INSERT INTO `test` ( `regdate` ) VALUES (unix_timestamp());   // 년월일 시분초 select DATE_FORMAT(FROM_UNIXTIME(regdate), '%Y-%m-%d %H:%i:%s') regdate from // 검색시 SELECT DATE_FORMAT( FROM_UNIXTIME( regdate ) , '%Y-%m-%d %H:%i:%s' ) regdate FROM test WHERE DATE_FORMAT( FROM_UNIXTIME( regdate ) , '%Y%m%d' ) = DATE_FORMAT( now( ) , '%Y%m%d' )   // BETWEEN 검색 SELECT DATE_FORMAT( FROM_UNIXTIME( regdate ) , '%Y-%m-%d %H:%i:%s' ) regdate FROM test WHERE DATE_FORMAT( FROM_UNIXTIME( regdate ) , '%Y%m%d' ) BETWEEN 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 DATE_FORMAT( FROM_UNIXTIME( regdate ) , '%Y-%m-%d %H:%i:%s' ) regdate FROM test WHERE DATE_ADD(FROM_UNIXTIME(regdate), INTERVAL '3' DAY), '%Y%m%d') BETWEEN DATE_FORMAT( DATE_ADD( now( ) , INTERVAL '-3' DAY ) , '%Y%m%d' ) AND DATE_FORMAT( DATE_ADD( now( ) , INTERVAL '3' DAY ) , '%Y%m%d' ) 그냥 간단히 자주 사용하는것만 정리해 보았습니다.