Results for “date_trunc”
Small, practical examples. Search by task or narrow things down below.
Read date components in UTC
JavaScript: UTC accessors avoid differences caused by the machine’s local timezone.
JavaScript✓ Tested
Read date components in UTC
TypeScript: UTC accessors avoid differences caused by the machine’s local timezone.
TypeScript✓ Tested
Read updated base-table values through a view
SQL: An ordinary view reflects later changes to its underlying data.
SQL✓ Tested
Read updated base-table values through a view
SQL Server: An ordinary view reflects later changes to its underlying data.
SQL Server✓ Tested
Read updated base-table values through a view
Postgres: An ordinary view reflects later changes to its underlying data.
Postgres✓ Tested
Read updated base-table values through a view
SQLite: An ordinary view reflects later changes to its underlying data.
SQLite✓ Tested
Roll back a trial update
Group a change in a transaction and undo it.
transaction✓ Tested
Schedule a one-time update with cleanup
Schedule a one-time update with cleanup with a small React component and explicit browser behavior.
React✓ Tested
Skip weekends when advancing dates
Python: Walk calendar dates and count only Monday through Friday.
Python✓ Tested
Truncate a single line
Combine CSS overflow and ellipsis for a constrained single line.
CSS✓ Tested
Type an object update with Partial
Allow a caller to provide just the fields to change.
Partial✓ Tested
Update a JSON document with mutable nodes
C#: JsonNode permits targeted changes before serializing a document again.
C#✓ Tested