Varchar to Timestamp Conversion

Harini · Post by **Harini** » Thu Nov 04, 2010 6:51 am

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

ArndW · Post by **ArndW** » Thu Nov 04, 2010 6:55 am

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

chulett · Post by **chulett** » Thu Nov 04, 2010 7:13 am

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

Harini · Post by **Harini** » Thu Nov 04, 2010 8:22 am

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

Thanks, that worked !

ArndW · Post by **ArndW** » Thu Nov 04, 2010 8:28 am

Craig - you gave away the secret

chulett · Post by **chulett** » Thu Nov 04, 2010 10:13 am

D'oh!

ray.wurlod · Post by **ray.wurlod** » Fri Nov 05, 2010 12:00 am

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.