InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Present A Past Time In Hours, Minutes And Seconds? |
|
Answer» If you want show an article was posted “n hours n minutes and n seconds ago’, you can use the TIMEDIFF(NOWO, pastTime) function as shown in the FOLLOWING are: SELECT TIMEDIFF(NOWO, ‘2006-07-01 04:09:49’) FROM DUAL; 06:42:58 SELECT TIM E_FORMAT(TI M EDI FF( NOWO, ‘2006-06-30 04:09:49’), ‘%H hours, %i minutes and %s seconds ago.’) FROM DUAL; 30 hours, 45 minutes and 22 seconds ago.If you want show an article was posted “n hours n minutes and n seconds ago’, you can use the TIMEDIFF(NOWO, pastTime) function as shown in the following are: |
|