Post
Ask Question

Date Functions in SOQL(Salesforce Object Query Language)

On development life we are daily use date function may be its for filter,Or its calculate reports .
 
Lets Create some of examples with using of date functions over Force.com(SOQL)
 
There are different date functions are available in SOQL. 
  • HOUR_IN_DAY() 
  • DAY_IN_WEEK()
  • DAY_IN_YEAR()
HOUR_IN_DAY():its help you to returns a number representing the hour in the day for a dateTime field.
 
Example:- SELECT HOUR_IN_DAY(convertTimezone(CreatedDate)) FROM ACCOUNT GROUP BY HOUR_IN_DAY(convertTimezone(CreatedDate))
 
OUTPUT:-22,2,3,6 
 
DAY_IN_WEEK(): its help you to returns a number representing the day of the week for a date field.
 
Example:- SELECT DAY_IN_WEEK(CreatedDate) FROM ACCOUNT GROUP BY DAY_IN_WEEK(CreatedDate)
  1. SUN DAY
  2. MON DAY
  3. TUE DAY
  4. WED DAY
  5. THU DAY
  6. FRI DAY
  7. SAT DAY 
DAY_IN_YEAR(): its help you to Returns a number representing the day in the year for a date field
 
EXAMPLE: SELECT DAY_IN_YEAR(CreatedDate) FROM ACCOUNT GROUP BY DAY_IN_YEAR(CreatedDate) 
 
2015-01-13T06:50:46.000+0000-13
2015-01-04T18:26:57.000+0000-4
2015-03-02T10:54:45.000+0000-61 
 
I will share you all other stubs that related to Date functions.