sqlcmd.net validated sql reference

Tag archive

#format

Commands grouped around the same concept, pattern, or recurring problem.

6 commands with this tag Browse related patterns quickly
intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Assemble A Key/Value String

Format several known values into one compact `key=value` string for transport or handoff.

intermediate date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Format A Date As A String

Convert a date value to a formatted string using a custom pattern such as MM/DD/YYYY.

intermediate conversion MySQL MariaDB SQL Server PostgreSQL SQLite

Format A Number As A Decimal String

Convert a numeric value into a formatted string with a fixed number of decimal places, optionally including thousands separators.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Join Text Values With Hyphens

Combine multiple text values into one hyphen-separated key-like string.

intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Pad A String To A Fixed Length With LPAD And RPAD

Left-pad or right-pad a string to a fixed width by filling with a repeated character.

intermediate conversion MySQL MariaDB SQL Server PostgreSQL SQLite

Parse A Formatted String Into A Date

Convert a text string in a known format into a native DATE value using engine-specific parsing functions.