You are so wrong, in so, so many ways. In SQL we have a strongly typed language that includes a date data type. You just posted absolute garbage. A date representation in ANSI/ISO standard SQL is based on the ISO-8601 standards, whose display format (which has nothing to do with internal representation) is”yyyy-mm-dd”, but it is not a character string.
This is like asking “on a scale from 1 to 10, what color is your favorite letter of the alphabet?”
Oh, and on top of that you don’t know that a column is nothing whatsoever like a field! The idea of something named a “attribute_value” is also totally absurd because it mixes data and metadata in a data element name. .
Can you post DDL and explain exactly what you’re trying to do in a consistent, rational, fashion that matches RDBMS?
Please post DDL and follow ANSI/ISO standards when asking for help.