Hi . You can use substring and concatenate functions to achieve your goal.
a=substring(SignedTime, 24, 4) Result= 2010
b=substring(SignedTime, 20, 4) Result=EST
and then use concatenate for
concat(a,"-",b,"-") result 2010-EST-
Substring doesn't seem to generate any value...
My intention is to insert the value in a database using a custom script. All this while, I have inserted the date as a string. However, converting this to a string gives me the zulu value.
Hİ my friend I got it now .
there is also date time format command which allows you to change datetime as you desired.
Maybe you can help me..... I am unable to get it to work. Have you used it before? Can you send me an example of how the parameters are used?