Date Fields and Timezones
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Date Fields and Timezones

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    4

    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,
    Matthew

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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