Store timestamp with timezone

Database
Enthusiast

Store timestamp with timezone

Hi Team,

There is a requirement to import record from File into a TD table.

There is a timestamp column with timezone.

For ex. 03/26/2015 04:00:32 PDT. How to define a field in table to store this value. Also how to validate this value?

Can anyone help me out?

Thanks

Krishna