Menu

#3259 dateformat converter produces wrong display

3.3.10
fixed
nobody
6
2013-06-11
2011-04-06
Anonymous
No

text/plain: dateformat displays
Apr 06, 2011 at 12:02 AM
for the number 1302040946

date -u @1302040946
shows
Wed Apr 6 00:02:26 CEST 2011

The wrong display is only for the time between 0:00 and 1:00

Discussion

  • Marc Delisle

    Marc Delisle - 2011-12-17
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2011-12-17

    Here, 1302040946 is supposed to be a UNIX timestamp?

     
  • Rouslan Placella

    How is the conversion wrong?

    00:02 am is the same as 12:02 am

     
  • Marc Delisle

    Marc Delisle - 2011-12-18
    • status: pending --> closed
     
  • Marc Delisle

    Marc Delisle - 2011-12-18

    From our doc for this transformation: "Displays a TIME, TIMESTAMP, DATETIME or numeric unix timestamp column as formatted date. The first option is the offset (in hours) which will be added to the timestamp (Default: 0). Use second option to specify a different date/time format string. Third option determines whether you want to see local date or UTC one (use "local" or "utc" strings) for that. According to that, date format has different value - for "local" see the documentation for PHP's strftime() function and for "utc" it is done using gmdate() function."

    It's difficult to analyse this bug without knowing which options were used and what is the local timezone for his server.

    Closing.

     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed