GitHub

CSV + JSON Cruncher - query and process your CSV and JSON files using SQL.

A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...
KnowTechie

How to link to a specific timestamp on YouTube

Just a heads up, if you buy something through our links, we may get a small share of the sale. It’s one of the ways we keep the lights on here. Click here for more. Over the years, YouTube has added ...
GitHub

Convert A String To A Timestamp

If you have a string that represents a point in time, there are a couple ways that you can convert it to a PostgreSQL timestamptz value. If the string is in ISO 8601 format, then it can be simply cast ...
TechRepublic

SQL basics: Datetime and interval data types

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...