Ternary operator in Oracle PL/SQL
Abstract: we need the max of two dates
Use this:
decode((date1 - date2) - abs(date1 - date2), 0, date2, date1)
AI Cybersecurity DefCon32 developer devops Devoxx DevoxxBE2012 DevoxxBE2013 DevoxxFR DevoxxFR2012 DevoxxFR2013 DevoxxFR2014 DotAI2024 Google Hibernate Java JavaScript JetBrains Jonathan Lalou Kotlin KotlinConf Kubernetes Maven Maven 2 Microservices NDCConferences ndcoslo NDCOslo2024 Node NodeCongress NodeCongress2021 NodeJS Oracle OxidizeConf2024 PHP Python recommendation RustLang Scala Security softwaredeveloper SoftwareDevelopment Spring SpringBoot Weblogic
Abstract: we need the max of two dates
Use this:
decode((date1 - date2) - abs(date1 - date2), 0, date2, date1)
Powered by WordPress and WordPress Theme | Host-euro.