Web Tools tools.bryantsmith.com

Database & SQL

MySQL Date Expression Builder

Pick a column and a date range to get a correct MySQL filter clause instantly — today, last 7 days, this month, year to date, and more. Everything is generated locally in your browser.

Runs in your browser No sign-up

Build the filter

live

Use created_at or table.column. Names that need quoting (reserved words, spaces, leading digits) are wrapped in backticks.

Add a table to wrap the filter in a complete SELECT statement.

Common ranges

Generated expression

MySQL

    How it works

    The builder writes standard MySQL date functions such as CURDATE(), NOW(), DATE_FORMAT(), and INTERVAL arithmetic. Calendar ranges use half-open bounds (column >= start AND column < end) to avoid double-counting the end of a period. Choose the UTC basis when you do not want the result to depend on the connection’s session time zone. Nothing is sent to a server — the SQL is produced entirely in your browser.

    Related tools

    • SQL IN-Clause BuilderTurn pasted values into quoted, escaped, deduplicated SQL IN lists — entirely in your browser.
    • SQL INSERT GeneratorPaste CSV, TSV, or JSON and instantly generate escaped, ready-to-run SQL INSERT statements in your browser.
    • Database Schema Diff ViewerCompare two CREATE TABLE schema definitions and highlight structural changes in tables, columns, indexes and foreign keys.
    • JOIN VisualizerVisualize INNER, LEFT, RIGHT, FULL and CROSS joins against tiny example tables, entirely in your browser.
    • SQL FormatterBeautify SQL for common dialects with live formatting, configurable keyword case and copy or download output.
    • SQL Identifier ConverterNormalize field and table names into snake_case, camelCase, PascalCase and other SQL naming conventions, entirely in your browser.

    More Database & SQL tools