A dashed date can change its mind with one session setting. Here is how to write dates that never do.
MySQL – Finding First day and Last day of a Month
MySQL has LAST_DAY to find the last day of a month but nothing built in for the first day. I show two simple methods to find the first day as well.
MySQL – How to Detect Current Time Zone Name in MySQL
Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.
SQL SERVER – Get Current TimeZone Name in SQL Server
What is the current TimeZone of the server where SQL Server is installed? Here is the short xp_regread script I use to read it.
MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME
Confused about TIMESTAMP or DATETIME in MySQL? I explain the two factors, starting with supported range, that help you decide which one to use.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
Counting Rows per Month With Zero-Filled Gaps
Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.