time stamp conversion

[samsuf2002]

DSGuru i divided the field into 2 parts using the stage variables A and B , A contain Jul 7 1998 12:19:52:236 and B contain PM . i used your code on A i got the output as 1998-07-17 12:19:52 . i am not getting :000 even after usin .3 in format. How should i use B i,e PM/AM to get 24 hrs format?

[us1aslam1us]

Use a Stage Variable:
sV >> If inTime = 'AM' then 1 else 0

In the Column Derivation:

Code: Select all

If sV = 0 then 
Field(incol," ",1):" ":TimeFromMidnightSeconds(
(HoursFromTime(Field(incol," ",2)) * 3600) + 
(MinutesFromTime(Field(incol," ",2)) * 60) + 
(SecondsFromTime(Field(incol," ",2))) + 
(12 * 3600)
) 
else incol

Test this...
IHTH

[DSguru2B]

Where are you changing the format? The StringToTimestamp() changes the string into a timestamp. The format of the timestamp will depend upon the default that is set in your target stage. I hope you are giving the .3 in the default timestamp of the target stage.

[samsuf2002]

i gave .3 in defaul format now iam getting .000 at the end of my date but i am expecting .236. Why it is not reading that.....???

[DSguru2B]

I dont think you will get that. It will only add zeros.