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
How to specify the timestamp format for the field like this?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Wed Jul 02, 2008 6:14 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 5
- Joined: Sun Jun 29, 2008 3:51 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
(Which advice I am sure I have given in the past on DSXchange.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.