A simple guide to SQL for AS400 Dummies You can spot my brethren fairly easily, the rare old-school AS400 developer can be found lumbering around your IT department. The trade mark style of these rare IBM Beasts is graying hair, a low-tech phone, typing with 2 fingers while muttering swear words under their breath. Counting Read More
iCommunity 2023 Meridian IT Ltd
iCommunity is a forum of IBM Power users, hosted by Meridian IT, an IBM Platinum Business Partner in the UK. To join, contact Meridian IT on 01564 330650 or email [email protected] www.themeridian.com Read More
POWERCast: 5 Ways to Protect the IBM I IFS from Cyberattacks COMMON
Speakers: TBD, SEA Price: Free Courtesy of SEA<b Read More
How to Build the Foundation of IBM i Security Defense Fortra
The most important step in crafting any successful IBM i security strategy is identifying the practices and tools that will serve as the foundation for your security efforts.
– Why building your IBM i security foundation is so important Read More
Using TO_CHAR to format timestamps [email protected] (Simon Hutchinson)
I use the SQL scalar function TO_CHAR all of the time to format numbers, inserting thousand separator characters. I can also use it for formatting timestamps.
In the following examples I am going to show how easy this, and it appears to duplicate a lot of the functionality of the EXTRACT scalar function.
In these examples I am going to show what I can do with a timestamp column, TIMESTAMP1, in a SQL DDL table, TESTTABLE.
Let me show you some examples of what I can do.
Read more » Read More