How to convert varchar to Date
Moderators: chulett, rschirm, roy
How to convert varchar to Date
I am getting varchar from source and i need to convert it to date? Can anyone assist me
Re: How to convert varchar to Date
1)Flat file ---- RDBMS stage(oracle,DB2 etc)
source=20080505target=iconv(source,'DYMD[4,2,2]') TARGET META DATA SHOULD BE DATEIF LEN(SOURCE)<8 THEN ICONV(SOURCE,'DYMD[2,2,2]')
ELSE IF LEN(SOURCE)=8 THEN iconv(source,'DYMD[4,2,2]')
ELSE IF
ELSE IF
ELSE
2)FLAT FILE FLAT FILE2008-06-06
OCONV(OCONV(SOURCE,'D-YMD[4,2,2]'),'D/YMD[4,2,2]')2008/06/06
2)FLAT FILE ORACLE2008-06-06
ICONV(OCONV(SOURCE,'D-YMD[4,2,2]'),'D/YMD[4,2,2]')2008/06/06 JULIAN DATE
ICONV(JULAINDATE,'DYMD')\ IF DATE IS NULL THEN @NULL
ELSE ICONV(DATE,"DYMD") IF ISNULL(TRIM(NAME)) THEN @NULL
ELSE SUBSTRINGS(NAME,1,10)
source=20080505target=iconv(source,'DYMD[4,2,2]') TARGET META DATA SHOULD BE DATEIF LEN(SOURCE)<8 THEN ICONV(SOURCE,'DYMD[2,2,2]')
ELSE IF LEN(SOURCE)=8 THEN iconv(source,'DYMD[4,2,2]')
ELSE IF
ELSE IF
ELSE
2)FLAT FILE FLAT FILE2008-06-06
OCONV(OCONV(SOURCE,'D-YMD[4,2,2]'),'D/YMD[4,2,2]')2008/06/06
2)FLAT FILE ORACLE2008-06-06
ICONV(OCONV(SOURCE,'D-YMD[4,2,2]'),'D/YMD[4,2,2]')2008/06/06 JULIAN DATE
ICONV(JULAINDATE,'DYMD')\ IF DATE IS NULL THEN @NULL
ELSE ICONV(DATE,"DYMD") IF ISNULL(TRIM(NAME)) THEN @NULL
ELSE SUBSTRINGS(NAME,1,10)
Jagan617 wrote:I am getting varchar from source and i need to convert it to date? Can anyone assist me
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: