Automic Workload Automation

On AE V12 Oracle date query displays extra characters

  • 1.  On AE V12 Oracle date query displays extra characters

    Posted Aug 24, 2017 07:31 AM
    Hi,
    I've noticed in V12 of the Automation Engine that Oracle date fields return extra characters (.0).
    This can be seen below in an example SQL VARA.
    Also can be seen in the Report in an SQL Job.

    83wg47bavly3.pnghttps://us.v-cdn.net/5019921/uploads/editor/3b/83wg47bavly3.png" width="324">

    I insert similar data into a local table so I had to modify my query to eliminate these characters so that the Insert would not fail.

    Modified to 
    texabyc31b60.pnghttps://us.v-cdn.net/5019921/uploads/editor/4i/texabyc31b60.png" width="523">