Image | Audio | Video |
---|---|---|
X | X | X |
Returns a timestamp that indicates when an image, audio, or video in a database table was last updated.
Include file
Syntax
>>-UpdateTime--(--handle--)------------------------------------><
Parameters (data type)
Return values (data type)
Timestamp when image, audio, or video was last updated (TIMESTAMP)
Examples
Get the names of files for images in the picture column of the employee table that were updated in the last 2 days:
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 - UPDATETIME(PICTURE))< 2;