I'm trying to pull a value from a SQL DB with the datatype datetime, but I can't find a varible type in UCCX to load it. UCCX sees it as Java.Timestamp but I can't match it up with a varible type. I've tried Date & Time with no luck. I need to load it in to a Date varible type so I can read it back to the caller.
The datatype for the datetime field within CRS is java.sql.Timestamp. If you create a new variable, this datatype is not available from the drop down list, but you can type that in to the type and it seems to be able to create a variable of this type. When you go back to the dbget step, it will see that variable.