Sorry Kevin, I tried changing NLS parameter by going to tools preferences database and nls parameters option. Then I changed...
Yes Kevin, I tried exactly what you said. select sysdate from dual is showing date with time values. But if...
Okay, that is strange. The HH24:MM:SS should be showing in values because a date value does contain both date and...
Yes John, I even tried that before, forgot to mention about it. after setting up the NLS Data format, it...
And that is what I forgot. The default date string does NOT include the time.Execute the following statement in SQL*Plus...
Powered by Crowds Insight | Manage your Crowds in site