Zip…whatever

Today a good friend of mine, Damu asked for a function that could copy files from a source to destination based on modified date criteria. Although it could be easily accomplished in the command-line itself, I took upon myself as an exercise to create a wrapper function to do the same in case he wants to … Continue reading PowerShell – Get Files Modified In A Certain Date Range And Copy/Delete/Zip…whatever

Oracle – Data Visualization Of DateTime Stamps – The Big Picture 24-hour View By Date Using PIVOT

One of the interesting aspects of working with data is how every person can look at the same thing and come to different conclusions. No one is right or wrong but a good visualization will lead to good decision-making. One of the leading data visualization patterns is pivoting and pivoting is everyone’s first choice when … Continue reading Oracle – Data Visualization Of DateTime Stamps – The Big Picture 24-hour View By Date Using PIVOT

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

Oracle’s INTERVAL Datatype Basics & Usage Examples

Oracle “Interval” data type is a new data type that was introduced in version 9i. In simple, terms, prior to 9i, if one needed to find the “duration” between a start time and end time, the query syntax was not too awkward but results were not human friendly. Without INTERVAL's help In the example below, … Continue reading Oracle’s INTERVAL Datatype Basics & Usage Examples

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.”