1. Helge Tjelta
  2. as Valentina DB Server
  3. Dienstag, Februar 12 2019, 09:36 PM
  4.  Abonnieren via E-Mail
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 ?
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
the problem occured in xojo, but doing the same in VStudio gives the same problem.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Should be the same of course. Please, report it to the Mantis.
Kommentar
There are no comments made yet.
  • Seite :
  • 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