티스토리 툴바

Daum
Tistory
로그인

'timestamp'에 해당되는 글 2건

  1. 2010/08/02 mysql timestamp to datetime
  2. 2010/07/14 mysql date time to unix time stamp
DB2010/08/02 15:41

mysql timestamp to datetime


select FROM_UNIXTIME(UNIX_TIMESTAMP(now()));
Posted by 크롭바디
TAG timestamp
Trackback 0 Comment 0
DB2010/07/14 17:17

mysql date time to unix time stamp


SELECT UNIX_TIMESTAMP('2005-03-27 03:00:00');

datetime 형식으로 저장되어 있는 날짜 비교시... 응용하시오.
Posted by 크롭바디
TAG timestamp, unix
Trackback 0 Comment 0