I have varchar column which holds different values of data like 'ABC','20140424','04/24/2014','JAMES' etc.,. I have to filter only date like records from this columns so in this case it has to be '20140424','04/24/2014' and pass this value between 2 other timestamp(0) columns.
Something like column between startdate and end date ( where both start and end date are timestamp(0) columns).
I have used sys_calendar.calendar join to filter the reocrds only which is in date format. But facing difficulty in passing that value in between timestamp, any suggestion would be a great help.
Code used for filter:
How would you interpret the character string 'JUNE'? Is this the Gregorian month name, or a first name?
Is the format of these two DATE fields fixed? Whats the format of TIMESTAMP(0) column? Are they all different columns? Can you share more clear example with input & output?