Convert SignedDate to String

[#1]

How is it possible to convert the Signed Time from the PDFSignatureVerificationResult field to String, in workbench? When I assign the value to a string variable I get the zulu time.

Below is the example..

SignedTime = Thu Dec 09 15:52:48 EST 2010

String Value = 2010-12-09T20:52:48Z

Aditya

[#2]

Agnieszka Fisher 

[#3]

Agnieszka Fisher 

[#4]

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?

Aditya

[#5]

Hİ my friend I got it now .

there is also date time format command which allows you to change datetime as you desired.

[#6]

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.

Aditya

[#7]

Hi . You can use substring and concatenate functions to achieve your goal.

For example

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-