Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get summer time or winter time

User_RFKSXFeb 17 2021

Hi,
is there a way to get from the Oracle database by SQL if the date time is in summer time or in winter time?
I hope you have undestood the question.
I work in Italy and as the most of European Countries, during the summer time there is the practice of advancing clocks during warmer months and so I'd like to know if in Oracle it's possible to get this kind of information.
Oracle versione 10g
Thanks in advance
Mark

Comments
Post Details
Added on Feb 17 2021
2 comments
1,081 views