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.
Hello,
I’ve a question regarding date and time format of oracle apex.
Issue:
I want to store date and time to oracle db through oracle apex 20.1. but it isn’t supporting date and time and saving only date. but, when I’m changing date format of apex field to date and time its giving error ORA-01843 not a valid month.
while storing date and time use to_char(yourdate,’DD-MM-YYYY HH24:MM:SS’) to store date with time