Convert timestamp to MMDDCCYYHHMMSS

[Marley777]

Hi, thanks for reading. How can I convert a timestamp to MMDDCCYYHHMMSS? Thanks!!

[mallikarjuna36]

please read pallelextender pdf document.

[mallikarjuna36]

please read pallelextender pdf document.

[Marley777]

I read the PX PDF, but still trying to find a specific example. I trying to simply take CurrentTimestamp and convert it to MMDDCCYYHHMMSS.

[chulett]

Best to specify what the exact format is that you need to convert it from would be.

[Marley777]

Thanks for reading.

I'm trying to take the date suplpied by the DataStage CurrentTimestamp() function within a transformer derivation and convert it to MMDDCCYYHHMMSS.

[chulett]

Doesn't answer the question - what format is that in? You need to know that in order to know how to 'convert' it...

[chulett]

Doesn't answer the question - what format is that in? You need to know that in order to know how to 'convert' it...

[Marley777]

For a timestamp the format is %yyyy-%mm-%dd %hh:%nn:%ss, but I need to convert to %mm-%dd-%yyyy %hh:%nn:%ss

Thanks

[Marley777]

I going to try this, but there may be a better way. Can anyone think of a better approach?


DateToString(CurrentDate(),"%mm-%dd-%yyyy") : CurrentTime()

[Marley777]

Actually I'm going to try this instead


StringToTimestamp(DateToString(CurrentDate(),"%mm-%dd-%yyyy"),"%mm-%dd-%yyyy-%hh.%nn.%ss")


Is there a better way? Thanks!!!

[ray.wurlod]

If you already have a timestamp, which I infer from your original post in this thread, simply convert it to a string, then use substring and concatenation to build the new format. Converting all the internal delimiters to "" first will make this easier.

Assign stage variable svTS with

Code: Select all

Convert(" ;-", "", TimestampToString(InLink.TheTimestamp))

Build your output column as

Code: Select all

svTS[5,2]:svTS[7,2]:svTS[1,4]:svTS[9,6]

[ray.wurlod]

If you already have a timestamp, which I infer from your original post in this thread, simply convert it to a string, then use substring and concatenation to build the new format. Converting all the internal delimiters to "" first will make this easier.

Assign stage variable svTS with

Code: Select all

Convert(" ;-", "", TimestampToString(InLink.TheTimestamp))

Build your output column as

Code: Select all

svTS[5,2]:svTS[7,2]:svTS[1,4]:svTS[9,6]

[DSguru2B]

Or, just change the timestamp mask to whatever you want in the output stage by going to the extended properties. The date is stored internally. It could be displayed however you want, which is determined by the mask that is supplied at the project level, set in the administrator. To override that, change it in the extended properties of your column in your target stage.

[Marley777]

Thanks to everyone for you help.

Hi DSguru2B, it looks like the sequential file stage gives me the option to override the timestamp default. It's on the format tab in the sequntial file stage. Is this what you were thinking too? Thanks!!