Re: Understanding SqlTypeFamily of DATETIME

2022-09-15 Thread Parag Jain
I did the debugging and then I was able to figure out that during validation casting is not added for Char types if the target type is of SqlTypeFamily.DATETIME family but only works if target type is one of SqlTypeFamily.DATE, SqlTypeFamily.TIME, SqlTypeFamily.TIMESTAMP. Will have a look at the

Re: Understanding SqlTypeFamily of DATETIME

2022-09-14 Thread Julian Hyde
DATETIME is a type family, not a type. (Yeah, I know that some databases have a DATETIME type, but the SQL standard doesn’t.) I don’t know all the details, but I recall that a type family is used as a shorthand for a family of closely related types that can be implicitly converted from one to

Understanding SqlTypeFamily of DATETIME

2022-09-13 Thread Parag Jain
In the AbstractTypeCoercion class, I see here , that DateTime family contains types SqlTypeFamily.DATE, SqlTypeFamily.TIME, SqlTypeFamily.TIMESTAMP. Here