chulett wrote:I doubt you're "going wrong" anywhere. Just seems like you need to translate the colons into periods after you've gotten the timestamp, if you really need it in that format.
That's what I thought, but I'm looking for a simpler solution in getting a period instead of a colon in the time format.
By what you say, I get the current timestamp, and needs to replace the colon with period, and there I'm struck..
Doesn't really get any simpler. Don't you have the Convert function in PX? Or EReplace? While I agree it would be best to generate it the way you want it, but failing that it is easy enough to swap the delimiters:
chulett wrote:Doesn't really get any simpler. Don't you have the Convert function in PX? Or EReplace? While I agree it would be best to generate it the way you want it, but failing that it is easy enough to swap the delimiters:
Getting back to the original problem posted: getting the microseconds moved into the database table, we have found a simple solution: in a transform, change the datatype from Timestamp to Char(26) for the link to the db stage, even though the actual table is defined as Timestamp. This works, at least, with Oracle and TeraData.
ArndW wrote:Has this been fixed in DS 7.5.2 ?[/b] I don't get the microseconds with the options mentioned in the manual %yyyy-%mm-%dd %hh:%nn:%ss.x where x is a no between 0 and 6 for the microseconds. I have the Job Parameter override for Timestamp to be %yyyy-%mm-%dd %hh:%nn:%ss.6 Compile goes thru, but the job fails. I'll post the message later.
Adding .6 worked for me.. thanks. (%yyyy-%mm-%dd %hh:%nn:%ss.6)