Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Increase a DateTime with minutes from a field |
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 Team Elevate | 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 Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |