Skip to content

Database.Guide

reference

MySQL Date Format Specifiers (Full List)

February 6, 2023 by Ian

The following table contains a full list of format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and FROM_UNIXTIME() in MySQL.

Read more

Categories MySQL Tags dates, reference, what is

Binary Styles Supported by CONVERT() in SQL Server

January 24, 2023 by Ian

Below is a list of binary 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 binary.

We can use these styles when the input expression is binary(n), char(n), varbinary(n), or varchar(n).

Read more

Categories SQL Server Tags convert, mssql, reference, t-sql

XML Styles Supported by CONVERT() in SQL Server

January 31, 2023January 24, 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.

Read more

Categories SQL Server Tags convert, mssql, reference, t-sql, xml

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

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.

Read more

Categories SQL Server Tags convert, mssql, reference, t-sql

Numeric Styles Supported by CONVERT() in SQL Server

January 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.

Read more

Categories SQL Server Tags convert, mssql, reference, t-sql

JSON Functions & Operators in SQLite (Full List)

April 5, 2022 by Ian

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

Read more

Categories SQLite Tags functions, json, reference

Date & Time Units in MySQL (Full List)

October 25, 2021 by Ian

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

Read more

Categories MySQL Tags date format, dates, reference

List of MySQL Date Format Specifiers

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().

Read more

Categories MySQL Tags date format, dates, reference

List of Territories Supported by Oracle Database

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.

Read more

Categories Oracle Tags reference

List of NLS Parameters in Oracle Database

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.

Read more

Categories Oracle Tags reference
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 Next →

About | Privacy Policy

© 2026 Database.Guide • All rights reserved