Menu

#394 (ok 2.11.5) dateformat transformation and UNIX timestamps

closed-accepted
1
2008-03-01
2008-01-24
Tim Steiner
No

When using the text/plain: dateformat on a field with a UNIX timestamp, certain dates are displayed incorrectly.

For example, the timestamp 1201118296 (Jan 23, 2008 at 7:58 PM) is displayed as "Jan 14, 2012 at 11:36 AM"

It looks like the timestamp is being treated as 12/01/11 82:96

Discussion

  • Tim Steiner

    Tim Steiner - 2008-01-24

    Possible Fix: assume INT columns are timestamps.

     
  • Tim Steiner

    Tim Steiner - 2008-01-24

    Logged In: YES
    user_id=823440
    Originator: YES

    File Added: dateformat.patch

     
  • Marc Delisle

    Marc Delisle - 2008-01-25

    Logged In: YES
    user_id=210714
    Originator: NO

    Moved to patches.

     
  • Marc Delisle

    Marc Delisle - 2008-01-25
    • milestone: 794588 -->
    • labels: 509144 --> Displaying results
     
  • Marc Delisle

    Marc Delisle - 2008-01-27
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2008-01-27
    • milestone: --> For_immediate_release
    • priority: 5 --> 1
    • summary: dateformat translation displays incorrect date --> (ok 2.11.5) dateformat transformation and UNIX timestamps
    • status: open --> open-accepted
     
  • Marc Delisle

    Marc Delisle - 2008-01-27

    Logged In: YES
    user_id=210714
    Originator: NO

    Merged in subversion, thanks.

     
  • Marc Delisle

    Marc Delisle - 2008-03-01
    • status: open-accepted --> closed-accepted
     
MongoDB Logo MongoDB