Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

If you have not checked my quick intro to the Interval datatype here, please do so before reading on. Now, that we know the “interval” data type, let us see how we can extract out the individual components within it for both the “DAY TO SECOND” and “YEAR TO MONTH” variations. The following example should … Continue reading Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

Advertisements

Oracle nasty dates finder for the .Net folks – Fix “Year, Month, and Day parameters describe an un-representable DateTime.”

If you are querying Oracle from .Net and you get this error: Exception calling "Fill" with "1" argument(s): "Year, Month, and Day parameters describe an un-representable DateTime." ---> System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime. It is most likely because of DateTime column(s) having a value of 00000000 00:00:00 or because the … Continue reading Oracle nasty dates finder for the .Net folks – Fix “Year, Month, and Day parameters describe an un-representable DateTime.”