How to work on time in oracle apex /oracle database

#oracleapex #time #date #Oracledatabase #Sql #PLSql
In this video, I have explained how to work on date and time and different type of formats in oracle apex and oracle database in detail.
--------------Facebook Link------------
/ namoraapexify

[@mohamedsameer3549]

Is there any option "$('#id').attr('type', 'time');"
to get the 24 hrs format?

[@nam-ora-apexify]

You can not change it manually. It depends on client machine's time format. If local machine is in 24 hours time format it automatically show 24 hours format and can take input in 24 hour.

[@mohamedsameer3549]

Very helpful kindly do video in English

[@nam-ora-apexify]

Thanks I will try in the next time.

[@md.noor-e-alam9079]

Need help. Not working on Mozilla prior versions less than 57. Are there any solutions that work with all browsers? Please help.

[@jorgebernal837]

Hi experts I was looking your video about the apex itema called P2_NEW_TIME so your DA with javascript workking well because in my case these control works with IG COLUMN?
because the end users wants to type for example 0230 and the column auto complete to 02:30 = 02hours and 30 minutes thats is possible to do? thanks a lot

[@nam-ora-apexify]

Just create static id for IG column and write your JavaScript code in da or in global function or variable declaration. Customer just type 0230 it will put the digits right position automatically.

[@jorgebernal837]

@@nam-ora-apexify ok static id ready..! could you help me with the js code? thanks

[@nam-ora-apexify]

$("#STATIC_ID").attr('type','time');

[@jorgebernal837]

@@nam-ora-apexify thanks a I was lookin but its possible only validate HH:MI ? because I need to put time in HOUR and MINUTES and other IG column in HH24:MI format not second not AM or PM ? thanks

[@nam-ora-apexify]

It depends on client PC time format, you can not