Anonymous

Not logged in

  • Log in
SQLZoo

Functions Reference

From SQLZoo

Namespaces

  • Page
  • Discussion

More

  • More

Page actions

  • Read
  • View source
  • History
Language:Project:Language policy English
Functions
Concatenate strings
Extracting substrings
lower case
Finding Substring
Formatting numbers
Replace NULL
Conditional values
Time now
Format dates

SQL Functions

Standard SQL functions and some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.

ABSCURRENT_TIMESTAMPLENGTH+ INTERVALSUBSTRING(ansi)
AVGDATEPARTMAX+ (string)SUBSTRING
StringsDAYMINPOSITIONSUM
CASEDIVMINUTEQUARTERTAN
CASTEXTRACTMODRANKTO_CHAR(dates)
CEILFLOORMONTHREPLACETRIM
COALESCEHOURNULLIFRIGHTYEAR
CONCATIFNULLNVLROUND
COSINSTRPATINDEXSECOND
COUNTLEFT% MODULOSIN
CURRENT_DATELEN+(dates)SUBSTR
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects
  • Served by: Dipsy at 2025-07-03T01:17
  • Retrieved from "https://sqlzoo.net/w/index.php?title=Functions_Reference&oldid=40616"
    Category:
    • Languages pages

    Navigation

    • SELECT basics
    • quiz
    • SELECT from world
    • quiz
    • SELECT from nobel
    • quiz
    • SELECT in SELECT
    • quiz
    • SUM and COUNT
    • quiz
    • JOIN
    • quiz
    • More JOIN
    • quiz
    • Using NULL
    • quiz
    • Self JOIN
    • quiz

    Reference

    • NoSQL zoo
    • SELECT
    • Functions
    • SELECT .. WHERE
    • SELECT .. GROUP BY
    • SELECT .. JOIN
    • SELECT .. SELECT
    • INSERT .. VALUES
    • INSERT .. SELECT
    • UPDATE
    • DELETE
    • CREATE TABLE
    • CREATE VIEW
    • CREATE INDEX
    • DROP
    • ALTER
    • UNION
    • LEFT JOIN
    • NULL

    Wiki tools

    Wiki tools

    • Special pages

    Page tools

    Page tools

      User page tools

        More

        • What links here
        • Related changes
        • Printable version
        • Permanent link
        • Page information
        • Page logs

        Categories

        Categories

        • Languages pages
        • Powered by MediaWiki
        • This page was last modified on 16 May 2025, at 03:29.
        • Privacy policy
        • About SQLZoo
        • Disclaimers