WebNov 4, 2024 · If your timestamp is already UTC, then it is a simple transformation of the form TimestampToString (InLink.MyTimestamp, "%yyyy-%mm-%ssT%hh:%nn:%ssZ") You can extrapolate this to remove the Z then append the +hh:mm or -hh:mm for your own timezone. Share Follow answered Nov 4, 2024 at 7:27 Ray Wurlod 811 1 3 3
oracle - String to timestamp in datastage 9.1.2 - Database ...
WebApr 2, 2024 · Conversions from string parameters will expect strings in the same format, with the exceptions that the sign of a timezone with zero hours and zero minutes can be either plus or minus, and trailing zeros are allowed for fractional seconds up to a … WebJun 30, 2024 · 1 You need to specify the format in which the timestamp data are being received, as part of the StringToTimestamp () function. StringToTimestamp (inLink.MyValue, "%yyyy-%mm-%dd %dd-%nn-%ss.s") Share Improve this answer Follow answered Aug 16, 2024 at 10:36 Ray Wurlod 811 1 3 3 Add a comment Your Answer passion or obfuscation example
String to timestamp conversation - DSXchange
WebJul 10, 2024 · I would suggest using an Execute Command activity, to execute the UNIX datecommand with appropriate arguments. For example (AIX): Code: Select all date +%Y-%m-%dT%H:%M:%S.%s Pipe the result through trif you need to change the "T" to a space. Pipe the result through cutif you don't need all of the fractional second digits. http://www.dsxchange.com/viewtopic.php?t=95959 WebApr 16, 2012 · You can use DateToString() by specifying the format and again convert back the result to StringToTimestamp(). Top jwiles Premium Member Posts:1274 Joined:Mon Nov 15, 2004 2:50 am Postby jwiles» Mon Apr 16, 2012 3:20 am There is always the TimestampFromDateTime() transformer function - james wiles tin ore albion