Image | Audio | Video |
---|---|---|
X | X | X |
Returns a timestamp that indicates when an image, audio, or video was stored in a database table.
Include file
Syntax
>>-ImportTime--(--handle--)------------------------------------><
Parameters (data type)
Return values (data type)
Timestamp when image, audio, or video was stored (TIMESTAMP)
Examples
Get the names of all files for images that were stored in the picture column of the employee table more than a year ago:
EXEC SQL BEGIN DECLARE SECTION; char hvImg_fname[251]; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT FILENAME(PICTURE) INTO :hvImg_fname FROM EMPLOYEE WHERE(CURRENT TIMESTAMP - IMPORTTIME(PICTURE))>365;