Time picker?
724687Sep 30 2010 — edited May 3 2012I'm making an "Event" system, where people can imput Event data. An event would be on a certain day, from a certain time to a certain time. So I want to have an input field for a date (with a date picker), thats no problem. But the starting and ending times are the problem. Two questions there:
1. Which datatype should I use for these? A timestamp? But this contains the date too. I was thinking of having three fields in the table: date of the event, starttime end endtime. But there is no datatype "time" in Oracle, right?
2. Is there somthing like a "time picker" where you don't have to (or can not) select the date, but only a certain time?
How would you solve this in Apex (3.2)? I could also work with to timestamps to specify beginning and ending of the event, but an event will never be on two different days, so i'd really like to have the data stored seperatly from the starting and ending times... I'm a bit stuck here... every tip or suggestion is welcome