{"id":1185,"date":"2019-07-02T15:59:27","date_gmt":"2019-07-02T06:59:27","guid":{"rendered":"http:\/\/sarang.inmu.net\/?p=1185"},"modified":"2019-07-02T15:59:34","modified_gmt":"2019-07-02T06:59:34","slug":"mysql-timestamp","status":"publish","type":"post","link":"https:\/\/sarang.inmu.net\/?p=1185","title":{"rendered":"mysql timestamp"},"content":{"rendered":"\n<p>mysql\uc758 \ub0a0\uc790\ub97c \uacc4\uc0b0 \ud558\uae30 \uc704\ud558\uc5ec reg_date \ub77c\ub294 \uceec\ub7fc\uc5d0 int \uac12\uc744 \uc8fc\uc5b4 \ud0c0\uc784\uc2a4\ud15c\ud504 \uac12\uc744 \uc815\uc218\ub85c \uc785\ub825\ud588\ub2e4. \uc815\uc218\uc774\uae30 \ub54c\ubb38\uc5d0 \uacc4\uc0b0\uc744 \ud560 \uc218 \uc788\uace0 php \uc5d0\uc11c date() \ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ub208\uc5d0 \ubcf4\uae30 \ud3b8\ud55c \uc124\uc815\uc73c\ub85c \ub0a0\uc790\ub97c \ub9cc\ub4e4 \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub807\uc9c0\ub9cc \uc774\ub7f0 \ucf54\ub529\uc740 \uc544\uc8fc \uad6c\uc2dc\ub300\uc801\uc774\ub2e4. \ub098\ucc98\ub7fc \ub178\uce5c\ub124\ub4e4\ub9cc \ub0c4\uc0c8\ub97c \ud48d\uae30\uba74\uc11c \uc4f0\ub294 \uc218\uc2ed\ub144 \uc804\uc758 \ubc29\uc2dd\uc774\ub2e4. \ud604\uc7ac\ub294 timestamp\ub77c\ub294 \uceec\ub7fc\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \uc544\ub798\uc640 \uac19\uc774 \uc0c8\ub86d\uac8c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \ub54c \uc4f8 \uc218 \uc788\ub294 \uc608\uc81c\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<p>CREATE TABLE myTable(<br>    <code>no<\/code> int NOT NULL AUTO_INCREMENT,<br>    <code>user_name<\/code> VARCHAR(16) DEFAULT NULL,<br>    <code>reg_date<\/code> TIMESTAMP DEFAULT CURRENT_TIMESTAMP<br>) DEFAULT CHARSET utf8;<\/p>\n\n\n\n<p>\uc704\uc640 \uac19\uc774 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0 \uc0ac\uc6a9\uc790 \uc774\ub984\ub9cc \uc778\uc11c\ud2b8\ud558\uba74 \uc790\ub3d9\uc73c\ub85c \ud604\uc7ac\uc758 \uc2dc\uac04\uc774 reg_date\uc5d0 \ub4e4\uc5b4 \uac04\ub2e4. \uadf8\ub807\uc9c0\ub9cc \ub0b4\uc6a9\uc744 \uc140\ub809\ud2b8 \ud574\ubcf4\uba74 \uc815\uc218\uac00 \uc544\ub2c8\ub77c \uc6b0\ub9ac\uac00 \ud3c9\uc18c\uc5d0 \uc77d\uc744 \uc218 \uc788\ub294 \uc2dc\uac04\uc774 \ud14d\uc2a4\ud2b8\ub85c \ub4e4\uc5b4 \uac00 \uc788\ub2e4.<\/p>\n\n\n\n<p>2019-07-01 00:00:00<\/p>\n\n\n\n<p>\uc704\uc640 \uac19\uc740 \ubaa8\uc591\uc774\ub2e4. \ub300\ud55c\ubbfc\uad6d \uc0ac\ub78c\ub4e4\uc774 \uc77d\uae30 \ud3b8\ud55c \ubaa8\uc591\uc774\ub2e4. \uc704\uc640 \uac19\uc740 \ubaa8\uc591\uc744 \ub9ce\uc774 \uc4f0\uc9c0\ub9cc \uac00\ub054 \uc815\uc218\uac00 \ud544\uc694\ud560 \uc218 \uc788\ub2e4. \uadf8 \ub54c \uc544\ub798\uc758 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p>SELECT user_name, unix_timestamp(reg_date) as IntRegDate FROM myTalbe;<\/p>\n\n\n\n<p>\uc704\uc758 \ucffc\ub9ac\ub97c \ub0a0\ub838\uc744 \ub54c \uc815\uc218\ub85c \ub41c reg_date \uac12\uc744 \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>reg_date \uac12\uc744 \uc815\uc218\ub85c \uc800\uc7a5\ud558\ub358 \uc2dc\uc808\uc740 \uc815\ub9d0 \uc624\ub798 \uc804\uc774\ub2e4. \uc544\ub9c8\ub3c4 2002\ub144 \uc6d4\ub4dc\ucef5 \ub54c\ub098 \uadf8\ub7f0 \uc2dd\uc758 \ucf54\ub529\uc744 \ud588\uc744 \uac83 \uac19\ub2e4. \uc2dc\ub300\uac00 \ubc14\ub00c\uc5c8\uc73c\uba74 \uadf8\uc5d0 \ub9de\ucdb0 \uac00\uc57c \ub428\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 \ub098\uc774 \ud0d3\uc744 \ud558\uba74\uc11c \uc61b\ub0a0 \uc80a\uc740 \uc2dc\uc808\uc5d0 \uba38\ubb34\ub974\ub824\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p>\ub098\uc774\uac00 60\uc774 \ub418\uc5b4\uc11c\ub3c4 \uc774\uc0bc\uc2ed \ub300 \ub54c\uc5d0 \ub4e4\uc5c8\ub358 \uc74c\uc545\uc744 \uace0\uc9d1\ud55c\ub2e4. \uae38\uc744 \uac77\ub2e4 \ubcf4\uba74 \ub178\uce5c\ub124\uac00 \uc2a4\ub9c8\ud2b8\ud3f0\uc73c\ub85c \uc74c\uc545\uc744 \ud2c0\uace0 \uc800 \uc55e\uc5d0\uc11c \uac78\uc5b4 \uc628\ub2e4. \uadf8 \ub178\uce5c\ub124\uac00 \uc80a\uc5c8\ub358 \uc2dc\uc808\uc5d0 \uc720\ud589\ud558\ub358 \uc74c\uc545\uc774\ub2e4. \uc2dc\uac04\uc740 \ub204\uad6c\uc5d0\uac8c\ub098 \uadf8\ub7f0 \uc2dd\uc73c\ub85c \uba48\ucd94\uc5b4 \uc788\ub294 \uac83 \uac19\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql\uc5d0\uc11c reg_date \uac12\uc744 timestamp \ub85c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uac04\ub2e8 \uc124\uba85<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[34,149,75],"class_list":["post-1185","post","type-post","status-publish","format-standard","hentry","category-5","tag-mysql","tag-reg_date","tag-timestamp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":724,"url":"https:\/\/sarang.inmu.net\/?p=724","url_meta":{"origin":1185,"position":0},"title":"\uc9c0\uae08 \uc774 \uc21c\uac04\uc73c\ub85c\ubd80\ud130 \ub531 \uc77c\uc8fc\uc77c \uc804\uc744 mysql\uc5d0\uc11c \ud45c\ud604\ud574\ubcf4\uc790\uc790","author":"sarang","date":"2017\ub144 01\uc6d4 02\uc77c","format":false,"excerpt":"\uc5f0\uc0b0\uc774 \uc790\uafb8 \ud5f7\uae54\ub9b0\ub2e4. < \uc778\uac00? \uc544\ub2c8\uba74 > \uc778\uac00 #SELECT count(*) from myTable WHERE reg_date < (unix_timestamp() - (86400 * 7)); \uc704\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 where \uc774\ud558 \ubcfc\ub4dc\uccb4\uc774\ub2e4. reg_date\ub294 php\uc5d0\uc11c time()\ud568\uc218\ub098 mysql\uc5d0\uc11c unix_timestamp() \ud568\uc218\ub85c \uc800\uc7a5\ud55c \uac12\ub4e4\uc774\ub2e4. \uc704\uc758 \uc5f0\uc0b0\uc740 \uc9c0\uae08\uc73c\ub85c \ubd80\ud130 1\uc8fc\uc77c \uc774\uc804\uc5d0 \uc785\ub825\ub41c row \uac2f\uc218\ub97c \uc54c\ub824 \uc900\ub2e4. \uc55e\uc758 select\ub97c delete\ub85c \ubc14\uafb8\uba74 \uc9c0\uae08\uc73c\ub85c\ubd80\ud130\u2026","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":205,"url":"https:\/\/sarang.inmu.net\/?p=205","url_meta":{"origin":1185,"position":1},"title":"mariadb \uc124\uce58\uc640 \uac04\ub2e8 \uc124\uc815","author":"sarang","date":"2016\ub144 04\uc6d4 12\uc77c","format":false,"excerpt":"mariadb \ub97c \uacf5\ubd80\ud558\ub824\uace0 VM\uc5d0 \uae54\ub9b0 \ub9ac\ub205\uc2a4 \ucd5c\uc2e0\ubc84\uc804\uc744 \uc124\uce58\ud588\ub2e4. \ub9ac\ub205\uc2a4\ub294 centos 5\uc774\uace0 \uc124\uce58\ub41c mariadb\ub294 10.1.13 \ubc84\uc804\uc774\ub2e4. \uc774\ubb38\uc11c\uac00 \uc791\uc131\ub418\uace0 \uc788\ub294 \uc2dc\uc810\uc5d0\uc11c\ub294 \ucd5c\uc2e0\ubc84\uc804\uc774\ub2e4. yum\uc124\uce58\ub97c \ud558\uc600\uc73c\uba70 \/etc\/yum.repo.d\/ \ub514\ub809\ud1a0\ub9ac\uc5d0 mariadb.repo \ud30c\uc77c\uc744 vi\ub85c \ub9cc\ub4e4\uace0 \uadf8 \uacf3\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ub123\uc5c8\ub2e4. [mariadb] name = MariaDB baseurl = http:\/\/yum.mariadb.org\/10.1.13\/centos5-amd64 gpgkey = https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB gpgcheck = 1 \uc124\uce58\ud560 \ub54c \uc8fc\uc758 \uc0ac\ud56d\uc740\u2026","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":902,"url":"https:\/\/sarang.inmu.net\/?p=902","url_meta":{"origin":1185,"position":2},"title":"ajax\ub97c \uc0ac\uc6a9\ud574\uc11c \uc11c\ubc84\uc758 \uc2dc\uac04\uc744 \ubcf4\uc5ec \uc8fc\uae30","author":"sarang","date":"2017\ub144 12\uc6d4 16\uc77c","format":false,"excerpt":"\uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c setInterval() \uc744 \uc774\uc6a9\ud558\uba74 \uc9c0\uc815\ud55c \ubc00\ub9ac\uc138\ucee8\ub4dc \ub2e8\uc704\ub85c \ubb34\uc5b8\uac00\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4. \uc774 \ud568\uc218\uc5d0 ajax\ub97c \ub123\uc5b4\uc11c 1\ucd08\uc5d0 \ud55c\ubc88 \uc529 \uc2e4\ud589\ub418\uac8c \ud55c\ub2e4\uba74 \uc11c\ubc84\uc758 \uc2dc\uac04\uc744 \ube0c\ub77c\uc6b0\uc800\ub85c \ubcf4\ub0bc \uc218 \uc788\ub2e4. \uc11c\ubc84\uc5d0\uc11c \ud560 \uc77c\uc740 php\uc758 date()\ud568\uc218\uc640 time() \ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \uc2e4\uc2dc\uac04\uc744 echo\ud558\uba74 \ub41c\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c\ub294 util.php?mode=nowTime \ub9c1\ud06c\uc5d0\uc11c \uad6c\ud604\ud558\uc600\ub2e4. util.php \uc758 \ucf54\ub4dc \ub0b4\uc6a9\uc740 \uc544\ub798\uc640 \uac19\ub2e4. <?php $mode\u2026","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1329,"url":"https:\/\/sarang.inmu.net\/?p=1329","url_meta":{"origin":1185,"position":3},"title":"mysql database \ud14c\uc774\ube14\uc744 \ubaa8\uc870\ub9ac \ud55c \ubc88\uc5d0 \uc0ad\uc81c","author":"sarang","date":"2020\ub144 04\uc6d4 21\uc77c","format":false,"excerpt":"mysql\uc774\ub098 mariadb\ub97c \uc0ac\uc6a9\ud558\ub2e4\uac00 DB\ub294 \ub0a8\uaca8 \ub450\uace0 \uc548\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\ub9cc \uc0ad\uc81c\ud574\uc57c \ub420 \ub54c\uac00 \uc788\ub2e4. \ud14c\uc774\ube14\uc774 \uba87 \uac1c \uc548\ub418\uba74 drop table '\ud14c\uc774\ube14\uc774\ub984'; \uba87 \ubc88 \ud558\uba74 \ub418\uc9c0\ub9cc \ud14c\uc774\ube14\uc758 \uac2f\uc218\uac00 \ub9ce\uc744 \ub54c\ub294 \uadc0\ucc2e\ub2e4. \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc790.","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":744,"url":"https:\/\/sarang.inmu.net\/?p=744","url_meta":{"origin":1185,"position":4},"title":"CSS \ud639\uc740 JS \ud30c\uc77c\uc758 \uce90\uc2dc","author":"sarang","date":"2017\ub144 01\uc6d4 10\uc77c","format":false,"excerpt":"\ud648\ud398\uc774\uc9c0\ub97c \uac1c\ubc1c \ud560 \ub54c CSS, \ud639\uc740 JS\ud30c\uc77c\uc744 \uc678\ubd80\uc5d0 \ub450\uace0 \uc0ac\uc6a9\ud560 \ub54c\uac00 \ub9ce\uc774 \uc788\ub2e4. HTML\uc740 \uc218\uc815\ud560 \ub54c \uc989\uc2dc \ubc18\uc601\uc774 \ub418\uc9c0\ub9cc \uc678\ubd80\uc5d0 \uc788\ub294 \uc800\ub7f0 \ud30c\uc77c\ub4e4\uc740 \uce90\uc2dc \ub54c\ubb38\uc5d0 \uc989\uc2dc \ubc18\uc601\uc774 \ub418\uc9c0 \uc54a\uace0 CTRL + SHIFT + R \ud0a4\ub97c \ub20c\ub7ec\uc11c \ube0c\ub77c\uc6b0\uc800\ub97c \uc644\uc804 \uc0c8\ub85c \uace0\uce68\ud574\uc57c \ub41c\ub2e4. \uac1c\ubc1c\ud558\ub294 \uc0ac\ub78c\uc774\uc57c \uc704\uc758 \ud0a4\ub97c \ub20c\ub7ec\uc11c \uc0c8\ub85c\uace0\uce68 \ud55c\ub2e4\uc9c0\ub9cc \uae30\uc874\uc5d0 \ud648\ud398\uc774\uc9c0\ub97c\u2026","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":619,"url":"https:\/\/sarang.inmu.net\/?p=619","url_meta":{"origin":1185,"position":5},"title":"css3","author":"sarang","date":"2016\ub144 09\uc6d4 09\uc77c","format":false,"excerpt":"\ucd5c\uadfc \ud648\ud398\uc774\uc9c0 \uc791\uc5c5\uc744 \ud558\uba74\uc11c css \ub54c\ubb38\uc5d0 \uc9c4\ud589\uc774 \uc548\ub418\uace0 \uc788\ub2e4. \uacfc\uac70\uc5d0\ub294 \ud14c\uc774\ube14\ub85c \ub808\uc774\uc544\uc6c3\uc744 \uc7a1\uc558\ub294\ub370, \uc694\uc998 \uadf8\ub7f0 \uc2dd\uc73c\ub85c \ud654\uba74\uc744 \ub9cc\ub4e4\uba74 \uc2dc\ub300\uc5d0 \ub4a4\ub5a8\uc5b4\uc9c4\ub2e4. \ubb34\uc5c7\uc774\ub4e0 \uc2dc\ub300\uc5d0 \uac78\ub9de\uac8c \uc791\uc5c5\ud558\ub294 \uac8c \ubc14\ub78c\uc9c1 \ud558\ub2e4. \ub808\uc774 \uc544\uc6c3\uc5d0\uc11c \uc911\uc694\ud558\ub2e4\uace0 \uc0dd\uac01 \ub418\ub294 \uba87 \uac00\uc9c0 \uc694\uc810\uc744 \uc774 \uacf3\uc5d0 \uc815\ub9ac\ud558\uc5ec \ucc38\uc870 \ud558\uc790. \u00a0 display \uc18d\uc131\uc5d0\uc11c inline \uacfc inline-block \uc758 \ucc28\uc774\uc810 \uc608\uc81c \uc704\uc758\u2026","rel":"","context":"&quot;\ucef4\ud4e8\ud130&quot;\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/p7qW60-j7","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1185"}],"version-history":[{"count":1,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1185\/revisions"}],"predecessor-version":[{"id":1189,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1185\/revisions\/1189"}],"wp:attachment":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}