Unanswered: Oracle Date Datatype - Formatting date from US to Japan local time.
DB Server / UNIX server location: US timezone: CST
Query is initiated from client in Japan say "select x,y, sysdate .. from a,b;"
When the query returns results, the date data comes in US local time. I cannot change the db instance time or the UNIX server system time to Japan time. How can I format the sysdate (date datatype) to get the JAPAN time.
NOTE that when the US timezone changes, this should not affect the function.
PS : I had an almost similar need, and I created a function that returns the local date provided you give the local TZ name as argument (eg 'Asia/Tokyo'). If you store the tz name for each client, then you'll be able to calculate the local time for each of them with this function.
Last edited by RBARAER; 11-16-05 at 04:52.
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .