Standard partition template with ISO dates in ints or chars

Some programmers deemed it wise to write ISO dates in SQL in integer or text fields.

So instead of 08/01/2020 in a datetime field they write 20200108 in an int or a varchar field.

Given that the standard calendar in TX contains very handy fields such as MonthKey or HalfYearKey that are perfect for partitioning such tables, I'd like to see this as a standard feature as well.




Please sign in to leave a comment.