Microseconds as the default for DB2 timestamps
Moderators: chulett, rschirm, roy
Microseconds as the default for DB2 timestamps
Pulled the timestamp from a DB2 API stage and chose microseconds from the pull down in the extended options in order to get the milliseconds (2006-01-21-02.03.09.111111). I was wondering since it's a DB2 stage and it should always have milliseconds is there a way to at a project level or even server level have it default to always include microseconds? I tried changing the default in the project to something like %yyyy-%mm-%dd %hh:%nn:%ss:%cccccc but that didn't do the trick.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To have the default repeat in a project I at first made the change in a table definition and clicked on "make default" for all new table definitions. After which I found that in the Admin tool you can set the default format for the timestamp in the parallel tab. It asks you to uncheck "use system default" and then allows you to enter a new format. The fact that it has a "system format" there makes me think I am making this change in the wrong place. I'd love to have this format change be for the entire DS server. Is that something I can get at and change?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: