Needed current date in CCYY-MM-DD-HH.MM.SS.NNNNNN format

[HemaV]

Hi All,

when i used CurrentTimestampMS() in my transformer i'm getting the date as
"2013-04-16 07:46:40.626082" means the format is "YYYY-MM-DD HH:MM:SS.NNNNNN"

But I wanted the format to be in "CCYY-MM-DD-HH.MM.SS.NNNNNN'

Could you please let me know How to do achive this in transformer stage.


Thanks in Advance,

[ray.wurlod]

CurrentTimestamp() is going to generate a binary timestamp. Format only comes into the picture when you want to convert that to a string. The View Data utility necessarily has to convert to string so we humans can see the value.

The easy options are to specify a format string with TimestampToString() function, or to use a Convert() function to change the " " to "-" once the timestamp has been converted to string.