Image | Audio | Video |
---|---|---|
X | X | X |
µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À°¡ ¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£À» Ç¥½ÃÇÏ´Â ½Ã°£¼ÒÀÎÀ» ³ªÅ¸³À´Ï´Ù.
Include ÆÄÀÏ
±¸¹®
>>-UpdateTime--(--handle--)------------------------------------><
¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)
¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿ÀÀÇ ¸¶Áö¸· °»½Å½Ã ½Ã°£¼ÒÀÎ(TIMESTAMP)
¿¹
employee Å×À̺íÀÇ picture Ä÷³¿¡¼ ÃÖ±Ù ÀÌÆ² µ¿¾È °»½ÅµÈ À̹ÌÁö¿ë ÆÄÀÏ À̸§À» È®º¸ÇϽʽÿÀ.
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;