날짜 형식
Format | Format Syntax | Example |
---|---|---|
Date only | YYYY-MM-DD | 1999-01-01 |
Date, time, and time zone offset | YYYY-MM-DDThh:mm:ss+hh:mm YYYY-MM-DDThh:mm:ss-hh:mm YYYY-MM-DDThh:mm:ssZ |
1999-01-01T23:01:01+01:00 1999-01-01T23:01:01-08:00 1999-01-01T23:01:01Z |
SELECT Id
FROM Account
WHERE CreatedDate > 2005-10-08T01:02:03Z
날짜 문자
Date Literal | Example |
---|---|
YESTERDAY | SELECT Id FROM Account WHERE CreatedDate = YESTERDAY |
TODAY | SELECT Id FROM Account WHERE CreatedDate > TODAY |
TOMORROW | SELECT Id FROM Opportunity WHERE CloseDate = TOMORROW |
LAST_WEEK | SELECT Id FROM Account WHERE CreatedDate > LAST_WEEK |
THIS_WEEK | SELECT Id FROM Account WHERE CreatedDate < THIS_WEEK |
NEXT_WEEK | SELECT Id FROM Opportunity WHERE CloseDate = NEXT_WEEK |
LAST_MONTH | SELECT Id FROM Opportunity WHERE CloseDate > LAST_MONTH |
THIS_MONTH | SELECT Id FROM Account WHERE CreatedDate < THIS_MONTH |
NEXT_MONTH | SELECT Id FROM Opportunity WHERE CloseDate = NEXT_MONTH |
LAST_90_DAYS | SELECT Id FROM Account WHERE CreatedDate = LAST_90_DAYS |
NEXT_90_DAYS | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_90_DAYS |
LAST_N_DAYS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_DAYS:365 |
NEXT_N_DAYS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_DAYS:15 |
NEXT_N_WEEKS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_WEEKS:4 |
LAST_N_WEEKS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_WEEKS:52 |
NEXT_N_MONTHS:n | SELECT Id FROM Opportunity WHERE CloseDate > NEXT_N_MONTHS:2 |
LAST_N_MONTHS:n | SELECT Id FROM Account WHERE CreatedDate = LAST_N_MONTHS:12 |
THIS_QUARTER | SELECT Id FROM Account WHERE CreatedDate = THIS_QUARTER |
LAST_QUARTER | SELECT Id FROM Account WHERE CreatedDate > LAST_QUARTER |
NEXT_QUARTER | SELECT Id FROM Account WHERE CreatedDate < NEXT_QUARTER |
NEXT_N_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate < NEXT_N_QUARTERS:2 |
LAST_N_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate > LAST_N_QUARTERS:2 |
THIS_YEAR | SELECT Id FROM Opportunity WHERE CloseDate = THIS_YEAR |
LAST_YEAR | SELECT Id FROM Opportunity WHERE CloseDate > LAST_YEAR |
NEXT_YEAR | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_YEAR |
NEXT_N_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_N_YEARS:5 |
LAST_N_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate > LAST_N_YEARS:5 |
THIS_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate = THIS_FISCAL_QUARTER |
LAST_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate > LAST_FISCAL_QUARTER |
NEXT_FISCAL_QUARTER | SELECT Id FROM Account WHERE CreatedDate < NEXT_FISCAL_QUARTER |
NEXT_N_FISCAL_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate < NEXT_N_FISCAL_QUARTERS:6 |
LAST_N_FISCAL_QUARTERS:n | SELECT Id FROM Account WHERE CreatedDate > LAST_N_FISCAL_QUARTERS:6 |
THIS_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate = THIS_FISCAL_YEAR |
LAST_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate > LAST_FISCAL_YEAR |
NEXT_FISCAL_YEAR | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_FISCAL_YEAR |
NEXT_N_FISCAL_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate < NEXT_N_FISCAL_YEARS:3 |
LAST_N_FISCAL_YEARS:n | SELECT Id FROM Opportunity WHERE CloseDate > LAST_N_FISCAL_YEARS:3 |