위키
포럼
도구
바뀐글
랜덤

"LAST DAY"의 두 판 사이의 차이

(새 문서: category: Date ;LAST_DAY ;last day of month ;last_of_month *test set :input: 2011-11-11 :output: 2011-11-30 ==Bash== category: Bash <source lang='bash'> INPUT=2011-11-11 LAST...)
 
잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(다른 사용자 한 명의 중간 판 3개는 보이지 않습니다)
1번째 줄: 1번째 줄:
[[category: Date]]
[[category: Date]]
==개요==
;LAST_DAY
;LAST_DAY
;last day of month
;last day of month
9번째 줄: 10번째 줄:
==Bash==
==Bash==
[[category: Bash]]
[[category: Bash]]
<source lang='bash'>
<syntaxhighlight lang='bash'>
INPUT=2011-11-11
INPUT=2011-11-11
LAST_DAY=`date +%Y-%m-%d -d "$INPUT +1 month -${INPUT:8:2} days"`
LAST_DAY=`date +%Y-%m-%d -d "$INPUT +1 month -${INPUT:8:2} days"`
echo $LAST_DAY
echo $LAST_DAY
</source>
</syntaxhighlight>


==PHP==
==PHP==
[[category: PHP]]
[[category: PHP]]
<source lang='php'>
<syntaxhighlight lang='php'>
$date = "2011-11-11";
$date = '2011-11-11';
$last_day = date('Y-m-d', mktime(0, 0, 0, substr($date,5,2)+1, 0, substr($date,0,4)));
$last_day = date('Y-m-d', mktime(0, 0, 0, substr($date,5,2)+1, 0, substr($date,0,4)));
// 2011-11-30
// 2011-11-30
</source>
</syntaxhighlight>
<source lang='php'>
<syntaxhighlight lang='php'>
function last_day($day) {
function last_day($day) { return date('Y-m-d', mktime(0, 0, 0, substr($day,5,2)+1, 0, substr($day,0,4))); }
  return date('Y-m-d', mktime(0, 0, 0, substr($day,5,2)+1, 0, substr($day,0,4)));
echo last_day( '2011-11-11' );
}
</syntaxhighlight>
</source>


==SQL==
==SQL==
32번째 줄: 32번째 줄:
===MySQL===
===MySQL===
[[category: MySQL]]
[[category: MySQL]]
<source lang='sql'>
<syntaxhighlight lang='sql'>
SELECT LAST_DAY( "2011-11-11" );
SELECT LAST_DAY( "2011-11-11" );
</source>
</syntaxhighlight>


===Oracle===
===Oracle===
[[category: Oracle]]
[[category: Oracle]]
<source lang='sql'>
<syntaxhighlight lang='sql'>
SELECT LAST_DAY(TO_DATE('2007-12-15', 'yyyy-mm-dd')) FROM DUAL;
SELECT LAST_DAY(TO_DATE('2007-12-15', 'yyyy-mm-dd')) FROM DUAL;
-- returns 2007/12/31 00:00:00
-- returns 2007/12/31 00:00:00
44번째 줄: 44번째 줄:
SELECT TO_CHAR(LAST_DAY(TO_DATE('2011-02-22', 'yyyy-mm-dd')), 'yyyy-mm-dd') FROM DUAL;
SELECT TO_CHAR(LAST_DAY(TO_DATE('2011-02-22', 'yyyy-mm-dd')), 'yyyy-mm-dd') FROM DUAL;
-- returns 2011-02-28
-- returns 2011-02-28
</source>
</syntaxhighlight>


==See also==
==같이 보기==
*[[last_of_this_month]]
*[[last_of_this_month]]
*[[FIRST_DAY]]
*[[FIRST_DAY]]
*[[days in month]]
*[[days in month]]
*[[NEXT_DAY]]
*[[NEXT_DAY]]

2020년 11월 2일 (월) 02:34 기준 최신판

1 개요[ | ]

LAST_DAY
last day of month
last_of_month
  • test set
input: 2011-11-11
output: 2011-11-30

2 Bash[ | ]

INPUT=2011-11-11
LAST_DAY=`date +%Y-%m-%d -d "$INPUT +1 month -${INPUT:8:2} days"`
echo $LAST_DAY

3 PHP[ | ]

$date = '2011-11-11';
$last_day = date('Y-m-d', mktime(0, 0, 0, substr($date,5,2)+1, 0, substr($date,0,4)));
// 2011-11-30

function last_day($day) { return date('Y-m-d', mktime(0, 0, 0, substr($day,5,2)+1, 0, substr($day,0,4))); }
echo last_day( '2011-11-11' );

4 SQL[ | ]

4.1 MySQL[ | ]

SELECT LAST_DAY( "2011-11-11" );

4.2 Oracle[ | ]

SELECT LAST_DAY(TO_DATE('2007-12-15', 'yyyy-mm-dd')) FROM DUAL;
-- returns 2007/12/31 00:00:00

SELECT TO_CHAR(LAST_DAY(TO_DATE('2011-02-22', 'yyyy-mm-dd')), 'yyyy-mm-dd') FROM DUAL;
-- returns 2011-02-28

5 같이 보기[ | ]

원본 주소 "https://zetawiki.com/w/index.php?title=LAST_DAY&oldid=605439"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}