<前> 1 SELECT TO_CHAR(date1, 'MMDDYYYY:HH24:MI:SS') date1, 2 TO_CHAR(date2, 'MMDDYYYY:HH24:MI:SS') date2, 3 trunc(86400 * (date2 - date1)) - 4 60 * (trunc((86400 * (date2 - date1)) / 60)) seconds, 5 trunc((86400 * (date2 - date1)) / 60) - 6 60 * (trunc(((86400 * (date2 - date1)) / 60) / 60)) minutes, 7 trunc(((86400 * (date2 - date1)) / 60) / 60) - 8 24 * (trunc((((86400 * (date2 - date1)) / 60) / 60) / 24)) hours, 9 trunc((((86400 * (date2 - date1)) / 60) / 60) / 24) days,10 trunc(((((86400 * (date2 - date1)) / 60) / 60) / 24) / 7) weeks11 FROM date_table12 13 DATE1 DATE2 SECONDS MINUTES HOURS DAYS WEEKS 14,- - - - - - - - - - - - - - - - -女人,- - - - - - - - - - - - - - - - -女人,- - - - - - - - - - -,- - - - - - - - - - -,- - - - - - - - - - -,- - - - - - - - - - -,- - - - - - - - - - -,15,06202003:16:55:14 07082003:11:22:57 , 43岁,27岁,18岁,17岁,2,16,06262003:11:16:36 07082003:11:22:57 21, 6, 0, 12, 1 >之前 回到顶部
<前> 1,完成,SELECT 铸(date1 AS 时间戳),“Date",得到t,, 2,Date 3,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -作用;4,20-JUN-03 04.55.14.000000 PM 5,26-JUN-03 11.16.36.000000 >之前
<前> 1,SELECT TO_CHAR (time1 & # 39; MM/DD/YYYY HH24: MI: ss # 39;),“Date",得到date_table 2,Date 3,- - - - - - - - - - - - - - - - - -作用;4,06/20/2003 16:55:14 5, 06/26/2003 11:16:36 >之前
<前> 1,SELECT TO_CHAR (time1 & # 39; MM/DD/YYYY HH24: MI: SS: FF3& # 39;),“Date",得到date_table2 3, Date 4,- - - - - - - - - - - - - - - - - - - - - - -安康;5,06/20/2003 16:55:14:000 6, 06/26/2003 11:16:36:000 >之前
<前> ,1 SELECT time1,, 2,,,,,,,, time2,, 3,,,,,,,, substr ((time2 作用;time1), instr ((time2 作用;time1), & # 39;, & # 39;), +, 7日,2),秒,,4,,,,,,,,substr ((time2 作用;time1), instr ((time2 作用;time1), & # 39;, & # 39;), +, 4日,2),分钟,5,,,,,,,,substr ((time2 作用;time1), instr ((time2 作用;time1), & # 39;, & # 39;), +, 1,, 2),小时,6,,,,,,,,trunc (to_number (substr ((time2 作用;time1),, 1,, instr (time2 作用;time1, & # 39;, & # 39;)))),天,7,,,,,,,,trunc (to_number (substr ((time2 作用;time1),, 1,, instr (time2 作用;time1, & # 39;, & # 39;))),/, 7), weeks 8,,,得到date_table 9,,, 10, TIME1 time2 SECONDS MINUTES HOURS DAYS weeks 11,- - - - - - - - - - - - - - - - - - - - - - - -安康;- - - - - - - - - - - - - - - - - - - - - - - - - - - -,- - - - - -安康;- - - - - -安康;——安康;- - - - -,- - - - -安康;12,06/20/2003:16:55:14:000000 07/08/2003:11:22:57:000000 , 43岁,27岁,18岁,17岁,2,13,06/26/2003:11:16:36:000000 07/08/2003:11:22:57:000000 21, 06年,00,12,1 >之前