How to specify the timestamp format for the field like this?

kinsey0514 · Post by **kinsey0514** » Mon Jul 14, 2008 6:40 am

when I using a seq stage for reading a file,
i met a field like this format:Apr 13 2006 5:07:49:720PM
In column definition it is type of timestamp
how can i specify the timestamp format for this field

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 3:44 pm

Welcome aboard.

I don't know that there's a conventional format string for this timestamp format.

I'd try reading it as VarChar and modifying it to a conventional timestamp format (adding 12 to the hours if the designator is PM, changing the decimal placeholder from ":" to ".", changing MDY order to YMD order).

yulangok · Post by **yulangok** » Wed Jul 16, 2008 3:14 am

Good question! Very good question, because I also met this question and have not resolved.

shiva_eee4u · Post by **shiva_eee4u** » Thu Jul 24, 2008 4:28 am

yulangok wrote:Good question! Very good question, because I also met this question and have not resolved.

Good question..... because I also met this question and have not resolved. Can i will have solution for the problem? Any one plz......

mahadev.v · Post by **mahadev.v** » Thu Jul 24, 2008 5:03 am

Stop praising and applauding. Which part of Ray's answer did you not understand? What approach have you tried so far? What results did you get?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 5:17 am

You could read it as a VarChar (or maybe even Char) and convert it to a conventional timestamp format.

(Which advice I am sure I have given in the past on DSXchange.)