Exercise ( Date functions from Dual Table)

  1. Display Current date
  2. Display Current Time.
  3. Display current user name.
  4. Display Current date in July 3 1997 format
  5. Display Current date and the date after 78 days.
  6. Display Current date, day, 70 days after current date and its day also.
  7. Display the months between ‘JAN-10-65’ and ‘JUN-23-98’ take the input in specified format.
  8. Display the current date as Today’s date is : current date from system.
  9. Display Current date, time and user name.
  10. Display the day like Sunday or what for this date ‘July 4 1998’