![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Sat, Jan 6 2018 11:11 AM | Permanent Link |
Hershcu Sorin | Hi
I want to combine a Date and a Time field to one. Something like: "select MyDate + MyTime as MyDateTime from..." What is the right command? Thanks Sorin |
Sat, Jan 6 2018 6:17 PM | Permanent Link |
Fernando Dias ![]() | Sorin,
Try this: SELECT MyDate + (MyTime - TIME '0') FROM ... The expression (MyTime - TIME '0') is going to convert the original TIME value into an INTERVAL, that is after added to the DATE, resulting in a TIMESTAMP. -- Fernando Dias [Team Elevate] |
Sun, Jan 7 2018 3:56 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Hershcu
I like Fernando's approach - its sneaky. There is always the traditional CAST approach CAST(CAST(MyDate AS VARCHAR(10))+' '+CAST(MyTime AS VARCHAR(10)) AS TIMESTAMP) Roy Lambert |
Mon, Jan 8 2018 4:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Fernando,
<< Try this: >> Roy is right - that *is* sneaky... ![]() Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |