![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Tue, Mar 17 2015 4:55 AM | Permanent Link |
durumdara | Dear Support!
I have a table with two important fields. ActTime - TimeStamp - the starting of an event LenMins - Integer - the length in minutes I tried to create an SQL which get the end of the events. select ActTime , LenMins , ActTime + interval LenMins 'minutes' from TheEvents But the manager said that the interval must be constant value. Is it true? Version: 2.11 B3 So I cannot add these two values? Thanks for any information! |
Tue, Mar 17 2015 5:34 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | durumdara
>select > ActTime , LenMins , > ActTime + interval LenMins 'minutes' >from > TheEvents > >But the manager said that the interval must be constant value. Is it true? > >Version: 2.11 B3 > >So I cannot add these two values? The answer is yes you can but not as you're trying ActTime , LenMins , ActTime + CAST(LenMins AS INTERVAL MINUTE) Roy Lambert |
This web page was last updated on Monday, July 1, 2024 at 03:00 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |