timestamp to varchar

[alisoviejo]

Hi
Need to read a value from a timestamp / date column and load the max value to varchar.
Have used modify stage with the following conversion

string_from_timestamp[YYYY-MM-DD HH24:MI:SS](In.DateColumn)

Getting error
main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: "YYYY"
Expected destination field selector, got: ")"; input:
string_from_timestamp[YYYY-MM-DD HH24:MI:SS](in.DateColumn)
;
Any one had similar issues?

[ArndW]

Hello Aliso,

the format string should be of the form %yyyy-%mm-%dd %hh:%nn:%ss; I am not using a terminal with the PDF files available, but have used manual formatting without problems (well, no problem once I figured out how to define the attributes) before.