1. Helge Tjelta
  2. as Valentina DB Server
  3. Tuesday, February 12 2019, 09:36 PM
  4.  Subscribe via email
Odd problem with using max on a date...

select max(plan->end_date) as 'end' from crew
and
select max(Plan.end_date) as 'end' from crew, plan

does not give the same result... the last one gives me the right max date, but the first one gives a much sooner date.... WHY???
Should this not give the same result ?
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
Should be the same of course. Please, report it to the Mantis.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Helge Tjelta Accepted Answer
the problem occured in xojo, but doing the same in VStudio gives the same problem.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories