I use age to get the interval between to date fields. Their type is timestamp.
My code is as below:
select age(timestamp MySecondDateField, timestamp MyFirstDateField)
The data in my field contains:
How should I subtract two dates?
When I use age as below it works:
select age(timestamp '2001-04-10', timestamp '1957-06-13')