Hi Sir,
Good Afternoon,Sir Can you please guide me how to capture only time in apex and what will be the datatype in db and any configuration in frontend.
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
You can use the date picker and specify the format as HH24:MI and specify the maximum length of 5 characters, and in database field type should be date type.
Or take a text field, specify the maximum length is 5 characters, and the database field type should be varcahar2.
Thnks for your response sir,
Can we add those time after saving the form/interactive grid and store into db
If the data type is the date, it will be automatically saved as a whole date, for example, 01/11/2020 15:10:00. To get the time value from this data, use the to_char() function. Below is an example:
And if the data type is varchar2, it will be saved as is, and you can query it without using any function.
I want to add 2:30+2:30+2:00=7:00 as i am capturing time in different field with out date
Then use the text field only, and the data type should be varchar2.
Thnks sir,how to add the times as shown above because if we add 2:30+2:30 will get 4:60 how to get 5
I have already given you an example of it in your previous question. Please check.