sqlcmd.net validated sql reference

Tag archive

#timestamp

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

6 commands with this tag Browse related patterns quickly
intermediate date-time MySQL MariaDB SQL Server PostgreSQL

Convert a Timestamp to a Different Time Zone

Shift a stored UTC timestamp to a local time zone for display using engine-specific conversion functions.

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 date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Extract Date Parts From A Date Or Timestamp

Return components such as year, month, and day from a date or timestamp value.

intermediate filtering MySQL MariaDB SQL Server PostgreSQL SQLite

Filter A Date Range With A Half-Open Boundary

Use an inclusive start and exclusive end to match a whole date range without missing rows that include times.

beginner date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Get The Current Date And Time

Return the current date and time using `CURRENT_TIMESTAMP` or engine-specific functions.

advanced date-time MySQL MariaDB SQL Server PostgreSQL SQLite

Round a Timestamp Down to a Specific Unit

Truncate a timestamp to the start of a month, day, or hour using engine-specific functions.