Formatting of datetime strings

The format for a datetime string that is in effect for a statement that is executed at the local Db2 is not necessarily in effect for a statement that is executed at a different server.

Fields on installation panel DSNTIP4 (DATE FORMAT, TIME FORMAT, LOCAL DATE LENGTH, and LOCAL TIME LENGTH) and SQL processing options affect the formatting of datetime strings.

The formatting of datetime strings is described in String representations of datetime values. Unlike the subsystem parameters and options previously described, a value in effect for a statement executed at the local Db2 is not necessarily in effect for a statement executed at a different server. See Restrictions on the use of local datetime formats for more information.