Why is Postgres returning a timestamp instead of the expected date data type
for the first expression (the second returns a date)?
In other words, is this a known bug or is it design intent. The manuals did
not seem to appear to say this is intentional behaviour but is not SQL
standard.
select
the6campbells the6campbe...@gmail.com writes:
Why is Postgres returning a timestamp instead of the expected date data type
for the first expression (the second returns a date)?
select date '2001-03-30' - interval '1' year, date '2001-03-30' - integer
'365' from tversion
Would you expect a