How to get minimum time stamp from a table ?

  • Interview Candidate
  • 6
  • 10702

Showing Answers 1 - 6 of 6 Answers

Hitendra Yadav

  • Dec 15th, 2011
 

Just use min() function and find minimum timestamp from a table.

  Was this answer useful?  Yes

Susil Kumar Nagarajan

  • Jan 20th, 2012
 

Use the combination of To_char and MIN functions..
to_char(min(created),dd-Mon-yyyy hh:mm:ss)

Example:

Code
  1. SELECT to_char(min(created),dd-Mon-yyyy hh:mm:ss) Min_time FROM all_objects

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions