THANKS GUYS!!
DSGURU's Derivation worked like a charm !
Marking as resolved !
Char to Timestamp
Moderators: chulett, rschirm, roy
rockr - timestamp contains a time component. If your data doesn't have it you will need to add it, as DSGuru2B has already shown.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
That is your input maskDSguru2B wrote:Try the followingCode: Select all
StringToTimestamp(TRIM(INPUTCOL):"000000","%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.