IBM Books

Image, Audio, and Video Extenders Administration and Programming

ImportTime


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

image
dmbimage.h

audio
dmbaudio.h

video
dmbvideo.h

Syntax

>>-ImportTime--(--handle--)------------------------------------><
 

Parameters (data type)

handle (DB2IMAGE, DB2AUDIO, or DB2VIDEO)
Column name or host variable that contains the handle of the image, audio, or video.

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;


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]