Hi,
I am confused about how date datatype values actually gets stored in oracle database. If i send date in some timezone(though date type doesn't contain TZ but date corresponding to some TZ e.g. 28.02.2017 15:30:00 IST) so in acutal hardware which date is stored ? is it 28.02.2017 15:30:00 as per what i sent or 28.02.2017 10:00:00 the time on UTC.
I found in my analysis that dbtimezone is considered to store the dates irrespective of what time you are sending. If this holds true on hardware 28.02.2017 10:00:00 date must be stored.
Please advise.
-Rohit