DSXchange

Hello All,

Below is a varchar and i need to convert it to timestamp length 23, scale 3..

2009-01-15T00:08:13.109.

I used the below code and it doesnt work...

StringToTimestamp(DSLink316.DATE,"%yyyy-%mm-%dd %hh:%nn:%ss")

Any idea on the right code??

Thanks

StringToTimestamp(DSLink316.DATE[1,10]:' ':DSLink316.DATE[12,12],"%yyyy-%mm-%dd %hh:%nn:%ss.3")

In other words, by skipping the 'T' separator.

ArndW wrote:StringToTimestamp(DSLink316.DATE[1,10]:' ':DSLink316.DATE[12,12],"%yyyy-%mm-%dd %hh:%nn:%ss.3") ...

Thanks, that worked !

Craig - you gave away the secret

D'oh!

Just curious (and unable to check at the moment) - can you include the literal T in the format string? That would yield a simpler and self-documented solution.