This content has been marked as final. Show 4 replies
There is no special preference controlling the date format in Database | Utilities | Cart, so the behavior either must be automatic or dependent on the NLS setting.
You might check if Tools | Preferences | Database | NLS | Date Format already contains a time format component. If the Cart deploy of dates does not work even with the correct NLS format, then this may need to be bugged. Perhaps an improvement has already been made for the next release. Please let us know. I will ping the developer on this.
SQL Developer Team
Maybe it has nothing to do with your issue, but since you are having problems with the time part of date objects you could try to change the
AddVMOption -Doracle.jdbc.mapDateToTimestamp=falsefrom false to true in
[SQLDev install dir]/sqldeveloper/bin/sqldeveloper.confIf this actually works then probably there really is a little glitch to be fixed in the Cart.
Gary and Irian both have good suggestions to identifying your problem.1 person found this helpful
I believe when you install SQL Developer, the NLS setting for DATE does not include time portion. Select tools-preferences->NLS. When I set the DATE format, in my case to DD-MON-RR HH.MI.SS, the date field with the time portion is deployed to the cloud as expected. When I set the mask to just DD-MON-RR , the time portion is all 0. This is the correct behavior.
Thank you all who responded. Once I changed the NLS Date Format to include the time elements (HH:MI:SS) the export data included the time for all date attributes and was deployed with this information intact.