You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
copy pasting the example query into "Your answer" fails to validate as it has decimals while the Expected results do not:
select extract(epoch from (timestamp '2012-09-02 00:00:00' - '2012-08-31 01:00:00'));
can be fixed by turning into an integer with round:
select round(extract(epoch from (timestamp '2012-09-02 00:00:00' - '2012-08-31 01:00:00')));
but AFAIK the sample result is from that example query in the first place so not sure why.
The text was updated successfully, but these errors were encountered:
rngadam
changed the title
00050000-interval2.ex does not validate
00050000-interval2.ex reference query does not validate with expected results
Apr 13, 2024
https://github.com/AlisdairO/pgexercises/blob/master/questions/date/00050000-interval2.ex
copy pasting the example query into "Your answer" fails to validate as it has decimals while the Expected results do not:
can be fixed by turning into an integer with round:
but AFAIK the sample result is from that example query in the first place so not sure why.
The text was updated successfully, but these errors were encountered: