Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
A technical guide explaining how to change the author and committer timestamps for Git commits, including recent commits and those deeper in history.
PostgreSQL 19 adds new random() functions for generating random dates and timestamps, useful for creating test data.
A guide to using the Date.now() method in JavaScript for getting timestamps and simple date logic.
Explains how to use Kafka Connect's InsertField Single Message Transform (SMT) to add message timestamps to data sent to a sink.
A technical exploration of ksqlDB window start times, including creating streams, inserting test data, and querying windowed aggregations.
Explains the Terraform timestamp() function, its usage, and important considerations like ignoring changes.
Explains changes to window timestamp handling in KSQL aggregations and how to integrate them with Elasticsearch for visualization.
Explains how to store high-precision timestamps in MySQL using the DECIMAL type, including storage optimization and historical context.
A technical guide explaining the formula to convert Microsoft Excel date values into UNIX timestamp format.
