Sorry ArndW. I come from Lyon but I have a mandate in Canada.
Good word game, I never thought it.
Concerning your answer, I try it but in my Output, I have stars in place of the timestamp.
In input, I have the value "6/1/2002 01:00:00.000 PM" defined as Varchar(25)
and in output, I have "*******************" defined as Varchar or Timestamp (I tried both).
try writing to a PEEK or flat file and seeing if the value is written correctly, if YES then the answer is in the OCI stage & conversion, if not then the Px isn't parsing the date correctly. I use that function on incoming string data without the time portion and it works flawlessly.
You can set the input (Or Output) column format in the PX Sequential file stage.
If you define the required column as Type TimeStamp (rather than a Varchar) then on the format tab (SEQ file stage) set the property for [TimeStage->FormatString]
Then again this might have problems with the 'PM' part of the data.
How about reading the data as a Varchar and then using a Transformer to apply the function StringToTimestamp(InDate,"%yyyy-%dd-%mm %hh:%nn:%ss") as noted by ArndW.
Hi i was also doing something similar and am getting "*"'s in result field. Please let me know what should be input type amd length and in which format will this functaion accept date. Also what should be output type and lrngth.
Thanks in advance