I have a need to drop the time portion of a timestamp and store the data back into a timestamp field. The result basically changing the time portion to 00:00:00
Ive tried the following:
trans_dt = Timestamp_From_date(Date_From_Timestamp(tdatetime))
but am receiving the following error:
main_program: Error parsing modify adapter: Error in binding: Expected ')', got: "("
Expected destination field selector, got: ")"; input:
KEEP trans_dt
;
trans_dt = Timestamp_From_date(Date_From_Timestamp(tdatetime))
Please bear with me as I am new to using the Modify stage. I'm attempting to convert from using the transformer stage as recommended in the video tech tip.
The code in the transformer stage that I am replacing is:
TimestampFromDateTime(TimestampToDate(DSLink37.TDATETIME) ,"00:00:00")
Thanks in advance for the help
Modify to "truncate" timestamp
Moderators: chulett, rschirm, roy
Re: Modify to "truncate" timestamp
yes, nested function is not compatible with MODIFY stage.
Depending upon how many transformation you do and volume of the data. I would choose either of Modify vs Transformer.
From my experience I recommend Modify.
Depending upon how many transformation you do and volume of the data. I would choose either of Modify vs Transformer.
From my experience I recommend Modify.
Hi balajisr
Thank you...I got it.
Thank you...I got it.
Code: Select all
Because modify is much efficient than transformer stage