Please help StringToTimestamp

tini · Post by **tini** » Tue Aug 28, 2007 10:35 pm

I support to convert a string with varchar (17) and the data looks like 20070111124536777.
I need convert it to timestamp yyyy-mm-dd hh:nn:ss.
could someone help me please. Please give me the syntax too.
Thank you for your help

ArndW · Post by **ArndW** » Tue Aug 28, 2007 10:59 pm

Code: Select all

StringToTimeStamp(In.Col,'%yyyy%mm%dd%hh%nn%ss')

and Bob's your uncle as some Yorkshire friends of mine are prone to saying.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 29, 2007 1:17 am

Version 4 parallel job? Really?

tini · Post by **tini** » Wed Aug 29, 2007 2:11 pm

ray.wurlod wrote:Version 4 parallel job? Really?

oop! version 7.1 not 4x.
sorry

tini · Post by **tini** » Sun Nov 18, 2007 9:46 pm

If I try the code on 7.1 then it works without warning. but Try on version 7.5 then we get the error
Warning:--Input_file,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
do you know why? thanks

ray.wurlod · Post by **ray.wurlod** » Sun Nov 18, 2007 11:09 pm

You have more digits than are required (that is, your string includes fractional seconds, but your date format string does not).