1-Visitor

Question

Funny Bug? within MSSQL Select

Forum|Forum|6 years ago
November 4, 2019
2 replies
2726 views

Hey guys,

can someone explain me that "bug?" which is growing from 8.2 --> current version.

SELECT MAX(VALUE_TIME)

FROM MyEpicTableDataAnonym

result = 2019-10.12 .....

and

SELECT MAX(VALUE_TIME) AS EPICMAXTIME

FROM MyEpicTableDataAnonym

result = 2019-10.03 ..

results me in two different answers ...

Coding

Author

1-Visitor

No ideas?

14-Alexandrite

I'm afraid you'll need to provide more context to understand what you're asking.

Author

1-Visitor

If i do an SELECT without "AS MyFanceValue" I receive a different result then when i use "AS" in the select statement

Community Manager

Support

Hi @bot1q.

Please let us know if you found a solution for your issue. If one of the previous posts helped to solve it, please mark the appropriate one as the Accepted Solution. Otherwise, please post the solution you found and mark that as the Accepted Solution for the benefit of others with the same issue.

Regards.

--Sharon