View previous topic :: View next topic
|
Author |
Message |
Neeraj Kumar
New User
Joined: 24 Nov 2007 Posts: 7 Location: ABC
|
|
|
|
HI..
I've a date coumn in MMYYYY format..bt i need the output in YYYYMM format..can anyone suggest an SQL query..
Thanks. |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
you can use the query
SELECT SUBSTR(DATE_COL,3,4)||SUBSTR(DATE_COL,1,2) FROM TABLE
P.S: MMYYYY is not a valid date format .... |
|
Back to top |
|
|
Neeraj Kumar
New User
Joined: 24 Nov 2007 Posts: 7 Location: ABC
|
|
|
|
thanx..
actually this column is not accepting date from system..its just like another column..having MMYYYY format..coz DD is not required.. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
what you are saying is that you have a CHAR column that contains a MMYYY formated value and you want to have the result be YYMMM.
Ashimer gave you a very workable solution to re-format your char data. |
|
Back to top |
|
|
Neeraj Kumar
New User
Joined: 24 Nov 2007 Posts: 7 Location: ABC
|
|
|
|
yeah..rite..and thanx.. the above query is working fine..
earlier i was using cobol temp working storage variables for reformatting.. |
|
Back to top |
|
|
|