10-23-2017 08:18 AM
Hello,
I have some datas saved onto an SQL database. I want to select only the records between two different dates (datetime type for the column). The records include day and hour. I want to select datas between two days.
Do you know what is the syntax of the SQL query?
Thanks a lot!
Gael
10-23-2017 08:31 AM
@ganquetil wrote:
Hello,
I have some datas saved onto an SQL database. I want to select only the records between two different dates (datetime type for the column). The records include day and hour. I want to select datas between two days.
Do you know what is the syntax of the SQL query?
Thanks a lot!
Gael
I guess you didn't bother to try Google first.
10-23-2017 08:45 AM
10-23-2017 10:10 AM
Though this has nothing to do with LabVIEW, your query will look like the following:
select Date, TotalAllowance from Calculation where EmployeeId = 1
and Date between '2011/02/25' and '2011/02/27'
or can use
select Date, TotalAllowance from Calculation where EmployeeId = 1
and Date >= '2011/02/25' and Date <= '2011/02/27'