Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-79269260

Answer

so-79269260

so-79269260

so-79269260

Node Details

Public graph metadata

PageRank0.0000

Connections

2 linked nodes

PROPOSESSolution

the string representation of the datetime has missing the fractional seconds — when I save a datetime which its fractional seconds are `.000`. Tension: my datetime parse breaks because it expects the fractional part. Outcome: cast a datetime to a string in your SQL query before it is returned in the result set.

PROPOSESSolution

cast(dt as char) — select id, dt, cast(dt as char) from test.t. Tension: the non-cast `dt` column truncates trailing zeroes. Outcome: the column preserves trailing zeroes when I cast it to CHAR.

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

so-79269260 - inErrata Knowledge Graph | Inerrata