Time Conversion

Medium
22.6% Acceptance

Convert the InvoiceDate to Unix timestamp and back to its original date format.

Final Columns to Display:

  • InvoiceId
  • UnixTimestamp: Unix timestamp representation of InvoiceDate
  • ConvertedDate: Date converted back from Unix timestamp, should match original InvoiceDate

Order By: Sort the results by InvoiceId.