Mahara

  1. Bug #1353069
  2. Comment #5

Comment 5 for bug 1353069

Revision history for this message
Aaron Wells (u-aaronw) wrote : Re: db_format_tsfield() returning time value with offset on POstgres

Attaching a test script to help with troubleshooting time issues. It models the entire lifecycle of a timestamp in Mahara:

1. Epoch fetch from time()
2. Converted to a date-time string by db_format_timestamp()
3. Stored into the DB as a timestamp without timezone
4. Retrieved from the DB as an epoch
5. Converted into a human-readable string with strftime()