![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 1 of 1 total |
![]() |
Wed, Mar 9 2016 9:08 AM | Permanent Link |
Suzanne C Nuss | I am doing a simple date difference: DischargeDate-AdmissionDate = Length of Stay
Delphi XE7, ElevateDB 2.18b3 If i run this in EDBMgr, all is well - i get the difference in days. whether I use: Select from ClientProgram ClientProgram.DischargeDate -ClientProgram.AdmissionDate as LOS or Select from ClientProgram (ClientProgram.DischargeDate -ClientProgram.AdmissionDate as INTERVAL DAY) as LOS When i put the query into DelphiXE7 Query object and put the query into place (either syntax) I consistently get a result in milliseconds. Yes, i can adjust this on my report by dividing by 86400000 but it is driving me crazy. I trolled through the support groups on Interval arithmetic but didn't see anything that suggests my error. Any ideas? tia Suzanne |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |