DB2 Dates format by region
- Read more about DB2 Dates format by region
- Log in to post comments
To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.
Get date with European format..
To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.
Get date with European format..
With 9.7 DB2 LUW version, IBM makes a nod to all Oracle DBAs, much more numerous in the DB2 market.
For this reason, 9.7 version has introduced Oracle compatibility modes that let you perform tasks in DB2 with the ease and knowledge that all Oracle DBAs have. However, it is important to know the terminology's translation between Oracle and DB2 if you intend to get into the DB2 world.
In this first article, I relate a number of items from which this introduction is simple and can be read DB2 documentation easily, including general terminology, updates, utilities, and views.
These are the 20 most popular 2010 contents on IBM developerWorks. The TOP 20 is based on newsletter subscriber activity. Very interesting list, specially for developers.
In many cases it happens that for some reason changed the hostname in our operating system, if this is the case and we also have an installation of DB2 9.7 ESE and the operating system is Windows XP, the way our DB2 instance start up correctly is:
Suppose the old name is new is OLDNAME and NEWNAME...