LATEST ANSWERS

• 
  RE: How to extract time stamp values from Agile 8.5 PLM database? By lm344 - 2 days ago

  Sorry Kevin, I tried changing NLS parameter by going to tools preferences database and nls parameters option. Then I changed...

• 
  RE: How to extract time stamp values from Agile 8.5 PLM database? By lm344 - 2 days ago

  Yes Kevin, I tried exactly what you said. select sysdate from dual is showing date with time values. But if...

• 
  RE: How to extract time stamp values from Agile 8.5 PLM database? By Kevin Cummings - 2 days ago

  Okay, that is strange. The HH24:MM:SS should be showing in values because a date value does contain both date and...

• 
  RE: How to extract time stamp values from Agile 8.5 PLM database? By lm344 - 2 days ago

  Yes John, I even tried that before, forgot to mention about it. after setting up the NLS Data format, it...

• 
  RE: How to extract time stamp values from Agile 8.5 PLM database? By Kevin Cummings - 2 days ago

  And that is what I forgot. The default date string does NOT include the time.Execute the following statement in SQL*Plus...