Results for “Encoding & structured values”

HTMLInput constraints

Constrain a calendar date input ↗

HTML: Use ISO date values for the date control’s minimum and maximum.

HTML✓ Tested

SQLiteDates & time

Convert Unix time to a timestamp ↗

Interpret a seconds-since-epoch value as UTC.

unixepoch✓ Tested

Bash ScriptsArray operations

Copy an array independently ↗

Bash Scripts: A new array assignment copies element values rather than creating a shared reference.

Bash Scripts✓ Tested

SQL ServerDates & text

Count day boundaries between dates ↗

Compare date values with DATEDIFF.

DATEDIFF✓ Tested

PowerShellDates & numeric validation

Count days between calendar dates ↗

PowerShell: Parse an unambiguous format before subtracting date values.

PowerShell✓ Tested

PowerShellCollections & objects

Count items by group ↗

Group repeated values and report each count.

Group-Object✓ Tested

C++Ordering & set operations

Count occurrences in a sorted sequence ↗

C++: equal_range finds the half-open interval containing values equal to the key.

C++✓ Tested

C#LINQ transformations

Create a reusable one-to-many lookup ↗

C#: ToLookup groups values by key and returns an empty sequence for an unknown key.

C#✓ Tested

SQLiteTables & writes

Create a STRICT table ↗

Require values compatible with declared column types.

STRICT✓ Tested

SQLReporting & grouped calculations

Distinguish row count from non-null value count ↗

SQL: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Distinguish row count from non-null value count ↗

SQL Server: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Distinguish row count from non-null value count ↗

Postgres: COUNT(*) includes every row while COUNT(column) skips NULL values.

Postgres✓ Tested