The following example shows how to use the format_datetime() function to format a datetime value. The output is formatted with a single digit for the month and hour, and with four digits for the year.

This library is a general purpose SQL generator. Think of it as a typesafe and expressive SQL DSL (domain specific language), with support for rendering SQL formatted properly for MyBatis3 and ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

I faced an interesting challenge recently: I had to use Power Query to remove all non-ASCII characters from some text but maintain the readability of that text. Let’s take the French phrase “un garçon ...

IBM shipped the JOBLOG_INFO table function back in IBM i v7r2 as a way to view the joblog from PC-based client access apps, such as RUN SQL Scripts. I use it from time to time to get the joblog for ...

I've used DSPPGMREF for decades. There were some 3rd party software offerings along the way that did a better job of providing a complete object cross reference database. DSPPGMREF is what most people ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...