Kettle时间戳转日期时间

测试时间戳 ： 1719796051000     对应时间：2024-07-01 09:07:31

kettle流程图

1.表输入

SELECT '1719796051000' as K_time

2.1 JS 直接转换 

var date = new Date(Number(K_time));  // 1719796051000
Y = date.getFullYear() + '-';
M = (date.getMonth()+1 < 10 ? '0'+(date.getMonth()+1) : date.getMonth()+1) + '-';
D = (date.getDate() < 10 ? '0' + date.getDate() : date.getDate()) + ' ';
h = (date.getHours() < 10 ? '0' + date.getHours() : date.getHours()) + ':';
m = (date.getMinutes() < 10 ? '0' + date.getMinutes() : date.getMinutes()) + ':';
s = date.getSeconds() < 10 ? '0' + date.getSeconds() : date.getSeconds();
var dateTIme = Y+M+D+h+m+s ;

2.2 JS Function接口转换 ，直接写在Script

var dataTime_function = timeChuo(K_time); 

function timeChuo(timestamp) {
   var dateTime = new Date(Number(timestamp));  
   Y = dateTime.getFullYear() + '-';
   M = (dateTime.getMonth()+1 < 10 ? '0'+(dateTime.getMonth()+1) : dateTime.getMonth()+1) + '-';
   D = (dateTime.getDate() < 10 ? '0' + dateTime.getDate() : dateTime.getDate()) + ' ';
   h = (dateTime.getHours() < 10 ? '0' + dateTime.getHours() : dateTime.getHours()) + ':';
   m = (dateTime.getMinutes() < 10 ? '0' + dateTime.getMinutes() : dateTime.getMinutes()) + ':';
   s = dateTime.getSeconds() < 10 ? '0' + dateTime.getSeconds() : dateTime.getSeconds();
   return  Y + M + D + h + m + s;
}

 

2.3 JS Function接口转换 ，function接口单独写，方便调用

右键点击Script，点击 'Add new'

Iteam页面右键选择 'Set Start Script'

funcation内容填写

function timeChuo(timestamp) {
   var dateTime = new Date(Number(timestamp));  
   Y = dateTime.getFullYear() + '-';
   M = (dateTime.getMonth()+1 < 10 ? '0'+(dateTime.getMonth()+1) : dateTime.getMonth()+1) + '-';
   D = (dateTime.getDate() < 10 ? '0' + dateTime.getDate() : dateTime.getDate()) + ' ';
   h = (dateTime.getHours() < 10 ? '0' + dateTime.getHours() : dateTime.getHours()) + ':';
   m = (dateTime.getMinutes() < 10 ? '0' + dateTime.getMinutes() : dateTime.getMinutes()) + ':';
   s = dateTime.getSeconds() < 10 ? '0' + dateTime.getSeconds() : dateTime.getSeconds();
   return  Y + M + D + h + m + s;
}

Script页面调用

var dataTime_function02 = timeChuo(K_time);