365199_zh-CN

liliconcom

将日期/时间（低至毫秒）转换为变量

你好，

我试图将日期/时间转换为毫秒，以便插入到我在JSL脚本中使用的SQL语句中。 我这样做的典型方法通常是在变量（日期）周围加上单引号。 但是，当尝试对包含毫秒的日期/时间使用相同的方法时，它会在变量的每个结尾处添加两个单引号。 有人可以协助潜在地解决我的问题，和/或帮助我针对所寻找的结果指向另一个方向吗？

 

dt1 = Current Data Table ();

dt1 << New Column ("Year", Formula(Year(Today())));  
dt1 << New Column ("Month", Formula(Month(Today()))); 
dt1 << New Column ("Day", Formula (Day(Today()))); 

dt1 << New Column ("UpdateDate", Formula (Char( :Year ) || "-" || Char( :Month ) || "-" || Char( :Day ) || "-" ||
"12.20.00.000000"));

dt2 = dt1 << Summary (
 Group (:UpdateDate), 
 Link to Original Data Table (0)
); 

dt2 = current data table (); 

dt2 << Delete Columns ("N Rows"); 

date_id = dt3:UpdateDate << Get Values; 
date_ids = "'"||date_id||"'"; 

我想要的结果是这样-> Format：HTML Format Version：1.0 StartHTML：165 EndHTML：420 StartFragment：314 EndFragment：388 StartSelection：314 EndSelection：314

'2021-3-4-09.20.00.000000'

 

任何帮助表示赞赏！

 

脚本编写回复：将日期/时间（低至毫秒）转换为变量

你好@玷污，

 

我不确定脚本的哪一部分操作不正确，因为它没有立即可用。我做了几处更改，您能看看这是否满足您的要求吗？

 

Names default to here(1);

dt1 = New Table( "Date test",
 Add Rows( 1 ),
 New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [] ) )
);

dt1 << New Column ("Year", Formula(Year(Today())));  
dt1 << New Column ("Month", Formula(Month(Today()))); 
dt1 << New Column ("Day", Formula (Day(Today()))); 

//Original UpdateDate column
dt1 << New Column ("UpdateDate", Character, "Nominal", Formula (Char( :Year ) || "-" || Char( :Month ) || "-" || Char( :Day ) || "-" ||
"12.20.00.000000"));

//Option 1 - adjusting your script
dt2 = dt1 << Summary (
 Group (:UpdateDate), 
 Link to Original Data Table (0)
); 

dt2 << Delete Columns ("N Rows"); 

//Get the UpdateDate and add single quotes to each line
date_id = dt2:UpdateDate << Get Values; 
date_ids = list();
write("List of date_ids:");
for(i=1, i<= n items(date_id), i++,
 date_ids[i] = "'" || date_id[i]  || "'"; 
 write( "\!n" || date_ids[i] );
);

//Option 2 - include quotes in original column formula and then use associative array to find unique values
dt1 << New Column ("UpdateDateQuoted", Character, "Nominal", Formula ("'" || Char( :Year ) || "-" || Char( :Month ) || "-" || Char( :Day ) || "-" ||
"12.20.00.000000'"));

date_ids_2 = associative array(dt1:UpdateDateQuoted) << get keys;
write("\!n\!nDateID from associative array:\!n" || date_ids_2[1];)