Image | Audio | Video |
---|---|---|
X | X |
Returns the duration (that is, the playing time in seconds) of a WAVE or AIFF audio, or video.
Include file
Syntax
>>-Duration--(--handle--)--------------------------------------><
Parameters (data type)
Return values (data type)
Duration, in seconds, of a video, or the duration, in seconds, of a WAVE, AIFF or user-defined format audio (INTEGER). Returns a null value for audio in other formats.
Examples
Display the duration of all videos that are stored in the video column of the employee table:
EXEC SQL BEGIN DECLARE SECTION; long hvDur_vid; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT DURATION(VIDEO) INTO :hvDur_vid FROM EMPLOYEE;