DATE FORMAT
Moderators: chulett, rschirm, roy
DATE FORMAT
I AM GETTING DATE IN THIS FORMAT
EX:
SOURCE IS ORAOCI9 STAGE
42606------------> MMDDYY
120105------------>MMDDYY
112805------------>MMDDYY
TARGET IS ORAOCI9
CAN ANY ONE TELL ME HOW TO FORMAT THE ABOVE INTO YYYYMMDD FORMAT.
THANKS IN ADVANCE
EX:
SOURCE IS ORAOCI9 STAGE
42606------------> MMDDYY
120105------------>MMDDYY
112805------------>MMDDYY
TARGET IS ORAOCI9
CAN ANY ONE TELL ME HOW TO FORMAT THE ABOVE INTO YYYYMMDD FORMAT.
THANKS IN ADVANCE
to be a little more specific, use
Code: Select all
OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]")
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: DATE FORMAT
This has been discussed in many many postings in this forum. It would be nice if you clicked here.
gateleys
gateleys
-
- Participant
- Posts: 38
- Joined: Mon Feb 27, 2006 10:34 pm
- Location: Chennai
- Contact:
HI!
You can use TO_CHAR(COLUMN NAME,'YYYYMMDD') in the source query
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
Cognizant technologies,Perungudi
Chennai
date problem
Hi
if i use this code i am getting the following error:
data for column exceeds column width (8), row 33 (approx), data = 2006/08/22
My Target column length is 8 and sql type is varchar.
if i use this code i am getting the following error:
data for column exceeds column width (8), row 33 (approx), data = 2006/08/22
My Target column length is 8 and sql type is varchar.
DSguru2B wrote:to be a little more specific, useCode: Select all
OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]")
try this
Code: Select all
DIGITS(OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]") )
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
It worked.
Thank you
Thank you
DSguru2B wrote:try thisCode: Select all
DIGITS(OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]") )