Modify to "truncate" timestamp
Posted: Thu Jul 27, 2006 10:35 pm
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
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