Unsolved
This post is more than 5 years old
37 Posts
0
1305
August 3rd, 2011 13:00
Casting a Date as a Time (or, Why does Time to Duration care?)
The "Last Backup Details" source provides the start time of the last backup cast as a "date."
The "Time to Duration" operator requires a "time" field as input. (Yes, it means it; I started digging into this when my "T to D" output field was blank.)
I hope this is a basic question, but how does one recast a date as a time? (Yes, I tried re-casting it in a nearly random stage. That didn't help.)
(That's the fun thing about DPA: when you get frustrated about beating your head against the wall on one issue, the next approach you take on the same kind of problem might having you beat your head against a completely different wall in no time at all!)
Nick
No Events found!
DavidRussell1
141 Posts
1
August 5th, 2011 03:00
Hi Nick,
You cannot change the cast of a field on a data source however if you look at the fields on the next operator down you an click on the cast and it should give you the ability to change it.
However I also did a test here and I was able to feed a Date field into the "Time to Duration" operator and it correctly gave me the duration between the Date field and the end of the report window. This was using DPA 5.8.1.
Thanks
David
David Russell
EMC Technical Support
dplaflamme1
37 Posts
0
August 5th, 2011 06:00
Either my testing in 5.7.1 was incorrectly exeucuted (or interpretted), or there's a fix in 5.8 or 5.8.1 I'll benefit from.
Alas, our upgrade to 5.8.1 is on hold until we upgrade a related DB server for reasons unimportant to this point.
I'll try again on 5.7.1 and see if I simply misunderstood the results I was seeing (or if my DPA client was having a resource-constrained day).
Thanks, David.
Nick
dplaflamme1
37 Posts
0
August 5th, 2011 07:00
Armed with the knowledge that it should work, I returned to a simple report using Last Backup Details.
Start Time failed to be converted to a duration.
Queue Time succeeded.
Start Time succeeds when I first make it a key field.
Have I mentioned today how much I love this product? I must, or else I'd have given up in frustration already.
(There's a third theory, but that's between me and a therapist....)