Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Automic Workload Automation
Private Community
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
On AE V12 Oracle date query displays extra characters
1.
On AE V12 Oracle date query displays extra characters
0
Recommend
John O'Mullane
Posted Aug 24, 2017 07:31 AM
Reply
Reply Privately
Options Dropdown
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.
https://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
https://us.v-cdn.net/5019921/uploads/editor/4i/texabyc31b60.png"
width="523">
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic