Community
Ecosystem
Forum
Events
MPUG
Support
KnowledgeBase
Support Portal
Customer Portal
Training
CONTACT US
Back to MinistryPlatform Site
Back to MinistryPlatform Site
Your Knowledge Base is moving on
3/25/24
! Our new
Help Center
provides all the articles you know and love (plus so much more) in a one-stop shop. Ask your SPoC for details!
Knowledge Base
>
MinistryPlatform
>
Customization
>
Extending the Platform
>
SQL and Databases
>
SQL Functions
SQL Functions
Date Functions
GETDATE
DATEADD
DATEDIFF
DATEPART
DATENAME
FORMAT (SQL 2012+) — See
MSDN: FORMAT
MONTH — see
MSDN: MONTH
DAY — see
MSDN: DAY
YEAR — see
MSDN: YEAR
Dynamic Dates
Text Functions
CONVERT — see
MSDN: CAST and CONVERT
CAST — see
MSDN: CAST and CONVERT
CHAR — see
MSDN CHAR
CHARINDEX — see
MSDN: CHARINDEX
DATENAME
FORMAT (SQL 2012+) — See
MSDN: FORMAT
LEN — see
MSDN: LEN
REPLACE — see
MSDN: REPLACE
STUFF
SUBSTRING — see
MSDN: SUBSTRING
General Functions
ISNULL
COALESCE
CONVERT — See
MSDN: CAST and CONVERT
CAST — See
MSDN: CAST and CONVERT
FORMAT (SQL 2012+) — See
MSDN: FORMAT
TOP — See
MSDN: TOP
Aggregate Functions
AVG
(Average)
COUNT
MIN
MAX
SUM
(Total)
Subquery Functions
COUNT
EXISTS
STUFF
When autocomplete results are available use up and down arrows to review and enter to select.
Knowledgebase
MinistryPlatform
Customization
Extending the Platform
SQL and Databases
Relationships
Terminology
Primary & Foreign Keys
Beginning SQL
Intermediate SQL
Advanced SQL
SQL Comparisons
SQL Functions
Tokens
×
Share Feedback
Please help us improve the KB.
Was the KB article helpful?
Yes
No