GoogleCloudPlatform / professional-services-data-validator

Utility to compare data between homogeneous or heterogeneous environments to ensure source and target tables match
Apache License 2.0
400 stars 114 forks source link

Need standard format for INTERVAL columns in row validation #1214

Open nj1973 opened 2 months ago

nj1973 commented 2 months ago

Casting interval columns to string gives differing values based on the SQL engine. For example:

There does not appear to be formatting functions like there are for timestamps so we need to think about how to approach this.