View previous topic :: View next topic
|
Author |
Message |
bhaskar_kanteti
Active User
Joined: 01 Feb 2007 Posts: 123 Location: Hyderabad
|
|
|
|
Hi,
In my table the date is of type S9(8) Comp-3 and the value will be YYYYMMDD.
While i am unloading from this table i want the date to be as DDMMYY.
How can i convert this formatting while unloading.
Is there any way to do this. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
If you have a column in a table that is used to store dates why not just define it as a DATE column? I don't think you can rearrange in the unload utility.
You could try something like:
substr(digits(stupid_date),7,2) concat substr(digits(stupid_date),5,2) concat substr(digits(stupid_date),1,4) |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Craig,
reasons I have found for not using DATE datatype are:
1. direct conversion from vsam record to db2 row
2. some places (banks) use feb 30 to indicate end of month since their calculation routines are so primitive.
3. lack of knowledge concerning the power of DATE type calculations in DB2.
in short, ignorance and short sightedness.
being a consultant, I love it. |
|
Back to top |
|
|
|