sqlcmd.net validated sql reference

Tag archive

#conversion

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

4 commands with this tag Browse related patterns quickly
beginner date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Convert Timestamps To Dates

Strip the time portion from a timestamp so only the calendar date remains.

beginner conversion MySQL MariaDB SQL Server PostgreSQL SQLite

Convert Values With CAST

Change a value from one SQL type to another using an explicit cast.

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.

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.