SELECT TRM_TIMEST_SUST TIMESTAMP,
TIME(TRM_TIMEST_SUST) TIME,
HOUR(TRM_TIMEST_SUST) 시 ,
MINUTE(TRM_TIMEST_SUST) 분 ,
SECOND(TRM_TIMEST_SUST) 초
FROM QGDTTRM
WHERE YEAR(TRM_TIMEST_SUST) > 2000;
---------+---------+---------+---------+---------+---------+---------+-------
TIMESTAMP TIME 시 분 초
---------+---------+---------+---------+---------+---------+---------+-------
2001-03-08-11.01.16.941333 11.01.16 11 1 16
2001-03-08-11.01.17.065204 11.01.17 11 1 17
2001-03-08-11.01.17.230688 11.01.17 11 1 17
2001-03-08-11.01.17.637576 11.01.17 11 1 17
2001-03-08-11.01.18.403070 11.01.18 11 1 18
2001-03-08-11.01.18.711806 11.01.18 11 1 18
2001-03-08-11.01.18.851514 11.01.18 11 1 18
2001-03-08-11.01.19.200142 11.01.19 11 1 19
2001-03-08-11.01.19.537616 11.01.19 11 1 19
위와 같이 초를 뽑아 계산하면 되지 않을까요....
|