Lynn Pettis (6/6/2008)

---

You also stated that [arrival date] and [arrival time] are both datetime fields, what does this data look like (sample values would be nice to see)?

😎

tim.pinder (6/6/2008)

---

Lynn Pettis (6/5/2008)

---

What does the data in the following fields look like:

[INITIAL_ASSESSMENT_TIME] (char(4))

[TIME_SEEN_FOR_TREATMENT] (char(4))

[ATTENDANCE_CONCLUSION_TIME] (char(4))

[DEPARTURE_TIME] (char(4))

😎

Hi Lynn

It's just a four digit number.

Steve Jones - Editor (6/5/2008)

---

You might need to convert/cast to get to numerics and then do your math

select (cast(arrivetime as int)/60) 'Minutes'

tim.pinder (6/5/2008)

---

The [arrival date] and [arrival time] are two separate fields (WHY?), both are datetime.

Steve Jones - Editor (6/5/2008)

---

You don't need internal variables.

You might need to convert/cast to get to numerics and then do your math

select (cast(arrivetime as int)/60) 'Minutes'

Lynn Pettis (6/5/2008)

---

What does the data in the following fields look like:

[INITIAL_ASSESSMENT_TIME] (char(4))

[TIME_SEEN_FOR_TREATMENT] (char(4))

[ATTENDANCE_CONCLUSION_TIME] (char(4))

[DEPARTURE_TIME] (char(4))

😎