Page 1 of 1
ICONV Date / Time format mask
Posted: Mon Jun 24, 2013 3:38 pm
by MrBlack
Can someone help me with format mask, I'm reading in a text file with data like
So far I've only used ICONV for just the date portion but I have never done a date/time.
I would expect a mask something like
Code: Select all
ICONV(DSLink1.Arg, "D/MDY HH:MM:SS AM MST")
I did find this website but haven't been able to make any combinations to work so far
http://docs.intersystems.com/cache20082 ... VBS_ficonv
Re: ICONV Date / Time format mask
Posted: Mon Jun 24, 2013 5:45 pm
by SURA
You may get some hold by referring this thread.
viewtopic.php?t=135681&highlight=MM%2FDD%2FYY
Posted: Mon Jun 24, 2013 9:15 pm
by chulett
You have to split the date from the time and convert them separately.
Posted: Mon Jun 24, 2013 10:56 pm
by ray.wurlod
You have to split the date from the time and convert them separately. DataStage BASIC has no knowledge of timestamps in any form. And, in particular, there is no internal format of a timestamp in DataStage BASIC.
Curiously, perhaps, the supplied SDK Transforms and Routines do provide such a thing, though based on a zero point of 1970-01-01 00:00:00.
Posted: Mon Jun 24, 2013 11:10 pm
by chulett
What's your goal here?
Posted: Tue Jun 25, 2013 4:31 pm
by bheaton_IHC
Here's a template of what I've used before that will return it's output as a string in the Oracle To_Timestamp() format. You should be able to adapt this to suit your needs.
Code: Select all
Oconv(ICONV(Left(ExtractOvrdFile.EVENT_TIME_DTS,10),"D/MDY[2,2,4]"),"D-YMD[4,2,2]") : " " : Oconv(ICONV(Right(ExtractOvrdFile.EVENT_TIME_DTS,8), "MTS"),"MTS")
Posted: Tue Jun 25, 2013 4:33 pm
by MrBlack
Thanks bheaton_ihc! That's a good example and I should be able to modify that for what I need to do.
Posted: Tue Jun 25, 2013 6:06 pm
by chulett
It would have helped if you explained "what you need to do" in its entirety right off the bat rather then just ask about a part of the puzzle. At this point we still don't even know what that is.
Posted: Wed Jun 26, 2013 8:34 am
by MrBlack
chulett I did specify the boundries of the problem: Take a date time string and get it into a date-time data type in datastage. What I do with the data from there is my business and out of scope of the problem.
Now with the combined responses from ray.wurlord and bheaton_ihc the problem can be resolved. Thanks to ray we know that datastage/iconv can't handle date-time format masks and thanks to bheaton gives a solutions to separate the data into the two necessary elements for conversion into date-time data type.
Now if you have a more elegant solution I challenge you to post it, otherwise stop trolling that I didn't tell you my overall plan to rule the world when all I wanted was to get a text sting into a date-time data type.
Posted: Wed Jun 26, 2013 9:38 am
by chulett
Trolling? Get real.