GO:0032440:   2-alkenal reductase [NAD(P)] activity
Catalysis of the reaction: n-alkanal + NAD(P)+ = alk-2-enal + NAD(P)H + H+.