Date to Timestamp conversion

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 8:34 am

Hi Gurus,

I have timestamp field coming from informix database (12/15/2008 10:11:12 AM) and when i am using the data type for the target as Timestamp i am getting "2008-12-15T16:11:12.000Z" Not sure why i am getting this junk values "T" and "Z"...can anyone help me out..

Thanks in advance

chulett · Post by **chulett** » Thu Nov 12, 2009 8:43 am

First off, those are not "junk" values. The 'T' marks the date/time boundary and the 'Z' means Zulu time, a UTC offset of "00.00" in an ISO 8601 timestamp. See here for the standards, especially pages 2 and 7. What is your target?

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 9:11 am

Thanks a lot for the information Chulett .

My input field is timestamp field - "12/15/2008 10:11:12 AM" and my target is timestamp .

Can you please tell me how to resolve this issue

chulett · Post by **chulett** » Thu Nov 12, 2009 9:28 am

No, what is your target - a flat file, database table, what? What happens if you declare it as a Varchar there?

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 9:31 am

my target is a webservice...Let me check what happens if i declare it as vchar thanks

chulett · Post by **chulett** » Thu Nov 12, 2009 9:40 am

OK, if your target is XML for a webservice the original format posted should work fine, I would think. Have you tried actually using it yet?

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 9:57 am

I didnt make any conversion and tried but i gave me the same result...

I tried "TimestamptoString(DSLink12.usg_begin_dt, "%yyyy-%mm-%dd %hh-%nn-%ss.5")" ...when i try to a flat file it worked but with in a service it didnt....

I am not sure how to solve this problem

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 10:29 am

Somebody plz help me in resolving this issue...

ArndW · Post by **ArndW** » Thu Nov 12, 2009 11:01 am

The Zulu format for xml is a good one. What is your actual error when going to a service?

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 11:04 am

Not sure Arnd....

i am getting the result with in the service as "2008-12-15T06:00:00.000Z" I have defined the WISD output datatype as 25,5

ArndW · Post by **ArndW** » Thu Nov 12, 2009 11:07 am

And is that an error? I am not sure what you want.

If you do

Code: Select all

TimestamptoString(DSLink12.usg_begin_dt, "%yyyy-%mm-%dd %hh-%nn-%ss.5")

what is your output?

chulett · Post by **chulett** » Thu Nov 12, 2009 11:13 am

So, no actual error - you've just never seen that before and thought there was something wrong with it? Are you trying to send that to the webservice or getting it back from the webservice? Assuming the latter, just strip the "zulu" part and replace the "T" with a space.

pandujoy · Post by **pandujoy** » Thu Nov 12, 2009 12:56 pm

can you tell me how to do...sorry my ignorance

ArndW · Post by **ArndW** » Thu Nov 12, 2009 1:29 pm

Our problem is that we don't understand what your problem is.

chulett · Post by **chulett** » Thu Nov 12, 2009 1:54 pm

Can you answer my "Are you trying" question please?