Inserted Age from Date Function
I don't understand the type of data when insert "age "from "date function". What does" this duration" represent. For example on born on 1971, what is meant by age to be like 18948:00:00:00
2 answers ( 0 marked as helpful)
This is a data type which is why we convert it into age, duration data types look like this
That duration represents the time difference between the date column selected and the current local date. By default, it returned that value in days. To convert that into the "age" that we all know, we then had to convert it into years instead of days. Hope this helps!