Hi how to convert string to timestamp in transformer.
Can you help me with an example.
I tried this:
StringToTimestamp(link name,["%yyyy-%mm-%dd %hh:%nn:%ss"])
but its giving me a parse error.
may be i am missing something here.
conversion of string to timestamp
Moderators: chulett, rschirm, roy
conversion of string to timestamp
Thanks,
Pavan
Pavan
Re: conversion of string to timestamp
What is the format of the timestamp in the string? Can you post some sample data ?
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Re: conversion of string to timestamp
Just take out the [] :pavans wrote:Hi how to convert string to timestamp in transformer.
Can you help me with an example.
I tried this:
StringToTimestamp(link name,["%yyyy-%mm-%dd %hh:%nn:%ss"])
but its giving me a parse error.
may be i am missing something here.
StringToTimestamp(linkname.column name,"%yyyy-%mm-%dd %hh:%nn:%ss")
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.