SQL EXCEL 增加字符减少字符，SQL增加时间

SQL 丁

select  LK.IN_STATION_TIME, LK.IN_STATION_TIME +5/60/24 ,lk.*  from sfc.r_assy_tracking_t lk where serial_number in ('172682422642')

SQL才搭才
   
 SELECT SERIAL_NUMBER||'0'  AS A  FROM SFC.R_PCBA_TEST_T  WHERE  SERIAL_NUMBER='172880420233',

 SELECT  substr(LK.SERIAL_NUMBER,1,12) A, LK.* ,ROWID FROM SFC.R_ASSY_TRACKING_T  LK WHERE serial_number in (
   

excel才搭才

CONCATENATE(A267&0)  

=LEFT(B267,12)