The following article mainly describes how to correctly parse the current time obtained by DB2. If you encounter the current time obtained by DB2 in actual operations, but you do not know how to solve it correctly, the following articles must be good teachers and friends for you. The following is a detailed introduction of the articles. I hope you can learn from them.
Modify the password of the DB2 database administrator. The running environment of the DB2 database is win2003 + db2 v8.1. the DB2 administrator set during the installation process uses the administrator (system administrator ).
Get current year month day:
- SELECT current date FROM sysibm.sysdummy1
Obtain the current hour, minute, and second:
- SELECT current time FROM sysibm.sysdummy1
Obtain the current year, month, day, hour, minute, and second:
- SELECT current timestamp FROM sysibm.sysdummy1
Modify the password of the db2 database administrator 11: 27db2 running environment: win2003 + db2 v8.1. the db2 administrator set during the installation process uses the administrator (system administrator ).
Problem: Because the administrator password is too simple, it is not safe for the system and you want to change the password.
Steps:
1. Modify the logon password of administrator.
2. "Start"-> "Administrative Tools"-> "service"-> right-click "DB2-DB2-0" (db2 service name) select "properties"> "Log on" in the displayed window"
". \ Administrator" is found in this account, and then enter the password to be modified in the box after "password" and "Confirm Password. The above content is an introduction to how to get the current time resolution of the DB2 database. I hope you will get some benefits.
The above content is an introduction to how to get the current time resolution of the DB2 database. I hope you will get some benefits.