获取时间
new Date().getTime();
new Date(new Date().setHours(0, 0, 0, 0)).getTime();
new Date(new Date().setHours(0, 0, 0, 0) - 86400000).getTime();
new Date() - 86400000;
new Date(new Date().setHours(0, 0, 0, 0) - 86400000 * 6).getTime();
new Date(+new Date() + 8 * 3600 * 1000).toISOString().replace(/T/g, ' ').replace(/\.[\d]{3}Z/, '');
new Date(+new Date() + 8 * 60 * 60 * 1000 - 300000).toISOString().replace(/T/g, ' ').replace(/\.[\d]{3}Z/, '');
内置常用函数
获取Kettle环境变量的值
getEnvironmentVar("id")
getVariable("id", "")
设置Kettle环境变量的值
setEnvironmentVar("id","opopop")
setVariable("id","opopop", "r")
日期转字符串
var dValue = new Date()
var a = date2str(dValue,"yyyy-MM-dd HH:mm:ss")
执行SQL语句
var conn = "default";
var sql = "SELECT * FROM biz_video_info limit 2";
var data = fireToDB(conn, sql);
var videoName = data[0][2];
字符串转小写&大写
lower("Home")
upper("go")