Timestamp or timestamp with Timezone datatype

Timestamp or timestamp with Timezone datatype

 

  

Hi All,

I need to store the local time in the database because my application will be used across a couple of time zones.So do I have Timestamp datatype or Timestamp with timezone datatype in my DB?
What are the advantages of each?
My DB is on Oracle 9i.


Thanks and Regards

Narayan
Oracle LazyDBA home page