Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (151)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: reference

XML Styles Supported by CONVERT() in SQL Server

Posted on January 24, 2023January 31, 2023 by Ian

Below is a list of XML styles supported by the CONVERT() function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted when converting to XML.

Continue reading →
SQL Server convert, mssql, reference, t-sql, xml

Date & Time Styles Supported by CONVERT() in SQL Server

Posted on January 24, 2023 by Ian

Below is a list of date & time styles supported by the CONVERT() function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted.

Continue reading →
SQL Server convert, mssql, reference, t-sql

Numeric Styles Supported by CONVERT() in SQL Server

Posted on January 24, 2023January 24, 2023 by Ian

Below is a list of numeric styles supported by the CONVERT() function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted.

Continue reading →
SQL Server convert, mssql, reference, t-sql

JSON Functions & Operators in SQLite (Full List)

Posted on April 5, 2022 by Ian

Below is a full list of JSON functions and JSON operators available in SQLite.

Continue reading →
SQLite functions, json, reference

Date & Time Units in MySQL (Full List)

Posted on October 25, 2021 by Ian

Here’s a list of units that can be used in MySQL datetime and interval functions.

Continue reading →
MySQL date format, dates, reference

List of MySQL Date Format Specifiers

Posted on October 13, 2021 by Ian

Here’s a list of MySQL format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and UNIX_TIMESTAMP().

Continue reading →
MySQL date format, dates, reference

List of Territories Supported by Oracle Database

Posted on October 4, 2021 by Ian

Below is a list of territories that are supported by Oracle Database. These can be used when setting the NLS_TERRITORY initialization parameter.

Continue reading →
Oracle reference

List of NLS Parameters in Oracle Database

Posted on September 2, 2021 by Ian

Below is a full list of NLS parameters in Oracle Database, along with their default values, and scopes that each parameter is available in.

Continue reading →
Oracle reference

List of Number Format Elements in Oracle

Posted on August 31, 2021 by Ian

Below is a full list of the format elements that can be used to format numbers in Oracle Database.

Continue reading →
Oracle number format, reference

List of Languages Supported by Oracle Database

Posted on August 30, 2021 by Ian

The following table contains a list of territories that are supported by Oracle Database.

Continue reading →
Oracle reference
  • «
  • 1
  • 2
  • 3
  • 4
  • »

About Database.Guide | Privacy Policy