Date time query
Hi all,I am trying to make a script where I need to query data for the whole day. I have this sample code: dt = Open Database( Username=username ;Password=password0;APP=JMP;DATABASE=db01;",
"select *
from table
where date_time between '07/10/2023 00:00:00 AM' and '07/10/2023 11:59:00 PM'" );
Is there a way I can put 07/10/2023 00:00:00 AM and 07/10/2023 11:59:00 PM in a variable?I tried using t...