Can anyone explain this?
When looking for transactions based on timestamp in e.g. 2017 you can for instance do it like this:
...where timestamp >= to_date('2017','YYYY')
or
...where timestamp >=to_date('01.01.2017','DD
Why does these two expressions return different number of transactions? In my case the latter returns appox. 8 times as many. Is this an error in Oracle SQL or is it something I have missed?
Thx!
Brgds
IVer Erling Årva, Oslo
When looking for transactions based on timestamp in e.g. 2017 you can for instance do it like this:
...where timestamp >= to_date('2017','YYYY')
or
...where timestamp >=to_date('01.01.2017','DD
Why does these two expressions return different number of transactions? In my case the latter returns appox. 8 times as many. Is this an error in Oracle SQL or is it something I have missed?
Thx!
Brgds
IVer Erling Årva, Oslo
3 Comments
Active today
Comment
Have you ever tried to check via:
select to_date('01.01.2017', 'DD.MM.YYYY'),
to_date('2017', 'YYYY')
from dual;
Oh! What can possibly be the reason for this? Very strange if you ask me, but thanks for your help! I will make sure not to make that mistake again :-)
Brgds
IVer
Brgds
IVer
Recommended Posts
So this year I decided it was really about time I applied for the
@vExpert subprograms, and guess what! I'm in! So Thanks to our Programme Manager![2024-vExpert-PRO.png]()
![2024-vExpert-vSAN.png]()
![2024-vExpert-vSphere.png]()
![vexpert-badge-stars-2024.png]()
![vexpert-badge-year-2024.png]()
@vCommunityGuy and Sub Programme Business Units!
@vExpert subprograms, and guess what! I'm in! So Thanks to our Programme Manager
@vCommunityGuy and Sub Programme Business Units!
Exchange Server Roadmap Update.
MS have moved the release date for the next version of Exchange Server to the second half of 2025.
It requires Server and CAL licenses and will be accessible only to customers with Software Assurance,
https://techcommunity.microsoft.com/t5/exchange-team-blog/exchange-server-roadmap-update/ba-p/3421389
MS have moved the release date for the next version of Exchange Server to the second half of 2025.
It requires Server and CAL licenses and will be accessible only to customers with Software Assurance,
https://techcommunity.microsoft.com/t5/exchange-team-blog/exchange-server-roadmap-update/ba-p/3421389
