For timestamps, I just cast them as varchar. Nulls make it uglier, because you have to coalesce them with something, depending on if you want null to be less than everything else or not. In a real query, you'll end up combining coalesce and cast for every column you want to feed into the least function. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to handle null timestamps using coalesce in Teradata Ask Question. Asked 2 years, 8 months ago. Active 2 years, 8 months ago. Viewed 2k times. Jeet Patel Jeet Patel 1 1 1 bronze badge. The SQL Coalesce function evaluates the arguments in order and always returns first non-null value from the defined argument list.
NULL in Teradata. Nulls are neither values nor they signify values; they represent the absence of value. A null is a place holder indicating that no value is present. What is qualify in Teradata? What is cast function in Teradata? The result be the converted value. How do I trim in Teradata? Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.
0コメント