![Query to get list of month and year since specific date in Oracle (Hierarchical queries - CONNECT BY Example) ~ Oracle Apps Knowledge Sharing Query to get list of month and year since specific date in Oracle (Hierarchical queries - CONNECT BY Example) ~ Oracle Apps Knowledge Sharing](https://1.bp.blogspot.com/-9FrgyvUukYo/X7eaIz4gcCI/AAAAAAAARCA/UmXhgKIXAskvoGyBbmm0u-VITtJYPdy1ACNcBGAsYHQ/s646/Query%2Bto%2Bget%2Bmonth%2Band%2Byear%2Bsince%2Bdate%2Boracle.png)
Query to get list of month and year since specific date in Oracle (Hierarchical queries - CONNECT BY Example) ~ Oracle Apps Knowledge Sharing
![Date format incompatibility in linked server between SQL Server and Oracle - Database Administrators Stack Exchange Date format incompatibility in linked server between SQL Server and Oracle - Database Administrators Stack Exchange](https://i.stack.imgur.com/iTkib.png)
Date format incompatibility in linked server between SQL Server and Oracle - Database Administrators Stack Exchange
![SQL-Developer: How to change the date format of the result grid – “Why does my date column have no time?” | Oracle Deli SQL-Developer: How to change the date format of the result grid – “Why does my date column have no time?” | Oracle Deli](https://oracledeli.files.wordpress.com/2013/03/nls_pref_de1.jpg)