Which field type is better to store specific play time in video for postgres?
Time is for representing time of day

Interval is for representing durations

Interval is probably the best fit for locating instants inside a video recording,  but an integer or bigint count of frame number is another candidate.