When copying a date from the Grid Results of Oracle, and a timestamp is encountered, we should be pasting using Oracle syntax if Paste to Window > INSERT Body is used to get this content in the Query Analyzer. Currently we are using a generic formatting for date/timestamp not tied to a DB type.
'2013-03-19 16:07:32.227',
vs the more DB specific
TO_DATE( '2013-03-19 16:07:32', 'YYYY-MM-DD HH24:MI:SS')
Our Export tool uses DB specific formatting, so we should be using that from the Grid Results > (right click selection) > Paste to Window > INSERT Body
Issue #13043 |
New |
Completion |
No due date |
No fixed build |
No time estimate |