首先需要先转换成char类型
to_char(t.restime, 'yyyy-mm-dd hh24:mi:ss')
然后在转换为date
TO_DATE((to_char(t.restime, 'yyyy-mm-dd hh24:mi:ss')),'yyyy-mm-dd hh24:mi:ss')
再将两个date类型相减
to_number((TO_DATE((to_char(t.restime, 'yyyy-mm-dd hh24:mi:ss')),'yyyy-mm-dd hh24:mi:ss')-
TO_DATE(to_char(t.servertime, 'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')))* 86400
as miao
二。new timestamp
// Random rand = new Random();
// int year = rand.nextInt(30) + 70;
// int month = rand.nextInt(12);
// int date = rand.nextInt(30) + 1;
// int hour = rand.nextInt(24);
// int minute = rand.nextInt(60);
// int second = rand.nextInt(60);
// int nano = rand.nextInt(999);
// Timestamp t = new Timestamp(year, month, date, hour, minute, second, nano);