I am building a ADF application which will be accessed across globe.
I need below functionality for the pages containing date time fields.
1. date fields should render the date as per the user's local time zone. while entering date as well as displaying (both in the ADF input Form and in Table)
2. date should be saved in GMT, and should convert depending on logged in user's time zone. i.e. date in DB will be in single time zone.
I found several article on internet but nothing helped.
1. Now how to achieve it, I am really confused. can anyone help me out here.an example or a step by step process will be highly appreciated
2. what should be the data type of date in DB (date, 'timestamp', 'timestamp with time zone', or 'timestamp with local time zone' )