Select records in Database using SQL query between 2 dates

[ganquetil]

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

[njacacia]

---

@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.

[siva_usic]

Hello,

 Follow this link.

[Mark_Yedinak]

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'