DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001

    I would like to store info in a date/time field. However, in addition to the date and time, I also need to know what timezone this info is associated with. Is there a way to also store a time zone in a date/time for a field?

    Thanks in advance,

  2. #2
    Join Date
    Oct 2000
    Here are some ideas. You could associate a time zone with a userid. Also, you could set some sort of absolute time zone, e.g. GMT. A time zone should simply be an attribute.

    Using an absolute solves another problem that you will encounter if you are working with U.S and European users. Daylight Savings Time is different by one week than DST in Europe.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.