Timestamp to string in modify stage

[reddy12]

How can i change timestamp field into string and string to timestamp?
give me example on that.

specification property.

Thanks to all guys to sharing your ideas in DSXchange.

[diamondabhi]

search the forum, here are some samples:

string_from_timestamp (timestamp, string)
timestamp_from_string (string, timestamp)
timestamp_from_ustring (ustring, timestamp)
ustring_from_timestamp (timestamp, ustring)

[DSguru2B]

Same thing can also be done in a px transformer. StringToTimestamp() and TimestampToString() functions, I believe, in the transformer. You can find the complete list under Transforms, under Type Conversion when you right click on the extended derivation window.

[ray.wurlod]

In the Modify stage the format string is given in square brackets, the input argument (field name) is given in parentheses. For example

Code: Select all

string_from_timestamp[%yyyy-%mm-%dd %hh:%nn:%ss](MyTimestamp)

Note that minutes are specified as %nn, not %mm.

[reddy12]

I am not able to see the code
can you please type only the code?

In the Modify stage the format string is given in square brackets, the input argument (field name) is given in parentheses. For example

Code: Select all

string_from_timestamp[%yyyy-%mm-%dd %hh:%nn: ...[/quote]

[us1aslam1us]

A clear specification with format is given in Parallel Job Developer's guide, Page 28-10,28-11.

[reddy12]

here i am littile bit confusion wtih (timestamp)
string_from_timestamp[timestamp_format] (timestamp)

string_from_timestamp[%yyyy-%mm-%dd %hh:%nn:%ss](DATEFIELD)
Is this above code correct?

A clear specification with format is given in Parallel Job Developer's guide, Page 28-10,28-11.

[us1aslam1us]

Yes Perfect!!