Results 1 to 2 of 2

Thread: Date and Time Offset Issue in Migration

  1. #1
    Join Date
    May 2007
    Los Angeles, California
    Rep Power

    Default Date and Time Offset Issue in Migration

    We converted a client's e-mail and their old server used a GMT offset in calculating date/time. It appears that all old messages converted using GMT time and not the calculated offset.

    My questions are:

    1. Are there fields in the database we could parse and change to correct the times?

    2. If so, what and where are they? Can we write a script to do the math?

    TIA, Mark

  2. #2
    Join Date
    Jan 2008
    Rep Power


    Have a look at this document:
    Account mailbox database structure - Zimbra :: Wiki

    By changing the date column, you can change the date shown in the list view. However, I'm not entirely sure where it pulls the date from when one actually displays the message. There's also a change_date column that I didn't play with, or it could be pulled right from the blob.

Similar Threads

  1. GroupWise migration experience
    By nrc in forum Migration
    Replies: 3
    Last Post: 08-24-2010, 12:41 AM
  2. How to display time and date in "Received" column
    By celeron in forum Administrators
    Replies: 3
    Last Post: 01-28-2009, 01:26 AM
  3. Retriveing messages since date time
    By sparkybellaire in forum Developers
    Replies: 1
    Last Post: 10-09-2008, 02:05 PM
  4. Display full date and time on message list
    By mteixeira in forum Users
    Replies: 0
    Last Post: 06-24-2008, 01:21 AM
  5. Time and Date Issue
    By menonumesh in forum Administrators
    Replies: 3
    Last Post: 04-18-2007, 06:06 AM

Posting Permissions

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