User-Defined Functions in SQL: Expanding Your Database Toolkit

• PostgreSQL

  405 14,673 10.0 C

  Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

  

(There is the AGE() function to calculate same in PostgreSQL. MySQL also has TIMESTAMPDIFF() function which is not that straightforward too)

• sql-server-samples

  35 9,485 0.0

  Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge

  

I will be using Microsoft SQL Server to do the demo in this article, while also using some data readily available online - AdventureWorksDW2014

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• MySQL

  146 10,244 9.8 C++

  MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.

  

(There is the AGE() function to calculate same in PostgreSQL. MySQL also has TIMESTAMPDIFF() function which is not that straightforward too)

Suggest a related project