686322_ko-KR

liliconcom

날짜 반복

안녕하세요 여러분,

날짜를 반복하여 데이터베이스에서 일부 데이터를 가져오려고 합니다. 이 예에서는 6월부터 어제 날짜까지 반복하려고 합니다. 이것은 내 샘플 코드입니다. 그러나 작동하지 않습니다. 누군가 올바르게 수행하는 방법을 설명해 줄 수 있습니까? 티아

 

d = Today() - In Days(1);
dateNow = Format (d, "m/d/y");
startdate = "2023-06-01";

For( i = startdate, i <= dateNow, i++,

try(
dt = Open Database( "DSN=db ;UID=user123;PWD=qwerty;APP=JMP;DATABASE=zxcv;", 
"Select * from table1
where date_time between '" || [i] || " 00:00:00 AM' and '" || [i] || " 11:59:59 PM'",  
"dt1" );

));

자동화 및 스크립팅Re: 날짜 반복

// The Today() function returns the number of seconds since Midnight, January
// 1st, 1904 which includes the number of seconds since midnight today up 
// until the exact h:m:s the today() function was run.
// I assume you really want the value of the start of today.
dateNow = date mdy(month(Today()),day(today()),year(today())) - In Days( 1 );

startdate = Informat( "2023-06-01", "yyyy-mm-dd" );

// Assuming that you want to increment by 1 day, you need to add a
// days worth of seconds for each loop.  JMP dates are stored in
// the number of seconds since Midnight, January 1, 1904.  
For( i = startdate, i <= dateNow, i = i + In Days( 1 ), 

 // When you reference i or datenow or startdate and you don't want
 // the number of seconds, but rather the date value, you need to
 // use the format() function to convert from the number of seconds
 // to the date display form
 Try(
  dt = Open Database(
   "DSN=db ;UID=user123;PWD=qwerty;APP=JMP;DATABASE=zxcv;",
   "Select * from table1
where date_time between '" || Format( i, "m/d/y" ) || " 00:00:00 AM' and '"
    || Format( i, "m/d/y" ) || " 11:59:59 PM'",
   "dt1"
  );
 )
);