The comparison of datetime-CodePudding

1. I want to do a query according to time two datetime type mm/dd/yyyy SQL statements and how to write?
2. And how about the parameters of the query window to another window of data in the window

CodePudding user response:

refer to the original poster playboy365 posts:

1. I want to do a query according to time two datetime type mm/dd/yyyy SQL statements and how to write?
2. And how about the parameters of the query window to another window data window

1. I want to do a query according to time two datetime type mm/dd/yyyy SQL statements and how to write?

Use string comparisons.

For example,

Select * from TB where dt & gt;
='2009-01-01'
2. And how about the parameters of the query window to another window data window

?

W_2. Dw_1. Setitem (m, n, par)

CodePudding user response:

Whether that is
Select * from bianming where date & gt;='2009-01-01' and date & lt;
='2009-03-16'
How do I pass this window of SQL statements data window to another window, make the data window has selective display according to the requirement

CodePudding user response:

refer to the second floor playboy365 response:

yes
Select * from bianming where date & gt;='2009-01-01' and date & lt;
='2009-03-16'
How I pass the window of the SQL statement data window to another window, make the data window has selective display according to the condition of the

-- if it is a SQL SERVER.
Select * from bianming where date & gt;='2009-01-01' and date & lt;
='2009-03-16'Or

Select * from bianming where date between '2009-01-01' and '2009-03-16 s'

Later, don't understand what you mean.

CodePudding user response:

Select * from bianming where date between '2009-01-01' and '2009-03-16 s'
'2009-03-16' this is to convert a String format?
Question 2 is in a window I put a data window w_1 dw_1, and a query button, query button corresponds to a query window, the results of the query window 1 SQL is the problem, then how w_1 data window of data real-time updates?

CodePudding user response:

String ls_sql

Ls_sql=dw_1. GetSQLSelect ()

Dw_2. Setsqlselect (ls_sql)

Is this mean?

CodePudding user response:

Select * from bianming where diffdate (date, '2009-01-01') & gt;=0 and diffdate (date, '2009-03-16') & lt;=0

CodePudding user response:

refer to the original poster playboy365 posts:

1. I want to do a query according to time two datetime type mm/dd/yyyy SQL statements and how to write?
2. And how about the parameters of the query window to another window data window

1, col & gt;=: date1 and col & lt;=: date2
2, the message

OpenWithParm (w_employee, "James Newton")