함수 yesterday()

1 Bash

Bash

Copy

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

2 C#

C#

Copy

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

3 Excel

PHP

Copy

=TODAY()-1

4 PHP

PHP

Copy

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

PHP

Copy

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

PHP

Copy

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

5 SQL

5.1 MySQL

MySQL

Copy

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

MySQL

Copy

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

6 같이 보기

• yesterday (YYYYMMDD)
• day before yesterday
• 함수 today()
• 함수 tomorrow()