JohnO'Mullane

On AE V12 Oracle date query displays extra characters

Discussion created by JohnO'Mullane on Aug 24, 2017
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.png

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.png

Outcomes