위키
포럼
도구
바뀐글
랜덤

"함수 yesterday()"의 두 판 사이의 차이

잔글 (Jmnote 사용자가 Yesterday 문서를 함수 yesterday() 문서로 옮겼습니다)
잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(다른 사용자 한 명의 중간 판 2개는 보이지 않습니다)
3번째 줄: 3번째 줄:
==Bash==
==Bash==
[[category: Bash]]
[[category: Bash]]
<source lang='bash'>
<syntaxhighlight lang='bash'>
YESTERDAY="$(date -d 'yesterday' +%Y-%m-%d)"
YESTERDAY="$(date -d 'yesterday' +%Y-%m-%d)"
echo $YESTERDAY
echo $YESTERDAY
</source>
</syntaxhighlight>


==C#==
==C#==
[[category: Csharp]]
[[category: Csharp]]
<source lang='csharp'>
<syntaxhighlight lang='csharp'>
String yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
String yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
</source>
</syntaxhighlight>


==Excel==
==Excel==
[[category: Excel]]
[[category: Excel]]
<source lang='php'>
<syntaxhighlight lang='php'>
=TODAY()-1
=TODAY()-1
</source>
</syntaxhighlight>
 
==PHP==
[[category: PHP]]
<syntaxhighlight lang='php'>
$yesterday = date("Y-m-d", strtotime("-1 day"));
</syntaxhighlight>
<syntaxhighlight lang='php'>
$yesterday = date("Y-m-d", strtotime("yesterday"));
</syntaxhighlight>
<syntaxhighlight lang='php'>
$yesterday = date("Y-m-d", time() - 86400);
</syntaxhighlight>


==SQL==
==SQL==
24번째 줄: 36번째 줄:
===MySQL===
===MySQL===
[[category: MySQL]]
[[category: MySQL]]
<source lang='MySQL'>
<syntaxhighlight lang='MySQL'>
SELECT SUBDATE(CURDATE(),1);
SELECT SUBDATE(CURDATE(),1);
SELECT ADDDATE(CURDATE(),-1);
SELECT ADDDATE(CURDATE(),-1);
# 2013-03-13
# 2013-03-13
</source>
</syntaxhighlight>
<source lang='MySQL'>
<syntaxhighlight lang='MySQL'>
SELECT SUBDATE(CURRENT_DATE, 1);
SELECT SUBDATE(CURRENT_DATE, 1);
SELECT SUBDATE(SYSDATE(),1);
SELECT SUBDATE(SYSDATE(),1);
# 2013-03-13 12:11:31
# 2013-03-13 12:11:31
</source>
</syntaxhighlight>
 
==PHP==
[[category: PHP]]
<source lang='php'>
$yesterday = date("Y-m-d", strtotime("-1 day"));
</source>
<source lang='php'>
$yesterday = date("Y-m-d", strtotime("yesterday"));
</source>
<source lang='php'>
$yesterday = date("Y-m-d", time() - 86400);
</source>


==같이 보기==
==같이 보기==
*[[yesterday (YYYYMMDD)]]
*[[yesterday (YYYYMMDD)]]
*[[day before yesterday]]
*[[day before yesterday]]
*[[today]]
*[[함수 today()]]
*[[tomorrow]]
*[[함수 tomorrow()]]

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


1 Bash[ | ]

YESTERDAY="$(date -d 'yesterday' +%Y-%m-%d)"
echo $YESTERDAY

2 C#[ | ]

String yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");

3 Excel[ | ]

=TODAY()-1

4 PHP[ | ]

$yesterday = date("Y-m-d", strtotime("-1 day"));

$yesterday = date("Y-m-d", strtotime("yesterday"));

$yesterday = date("Y-m-d", time() - 86400);

5 SQL[ | ]

5.1 MySQL[ | ]

SELECT SUBDATE(CURDATE(),1);
SELECT ADDDATE(CURDATE(),-1);
# 2013-03-13

SELECT SUBDATE(CURRENT_DATE, 1);
SELECT SUBDATE(SYSDATE(),1);
# 2013-03-13 12:11:31

6 같이 보기[ | ]

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