soql to select time period code example

Example 1: string literal soql date format

//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

Example 2: soql last year

delete [SELECT Id FROM Opportunity WHERE CreatedDate = LAST_YEAR];