Soulver 3 for Mac, iPad & iPhone
  • Frequently asked questions
  • Changelog
  • Request a new feature
  • What's new in Soulver 3?
  • Features
    • Getting Started
    • Totals & Subtotals
    • Line References
    • Variables
    • Formatting
      • Number Formats
      • Text Stying
      • Answer Formatting
    • Sheets & Files
      • Sheets
      • Sheetbooks
      • Soulver Files (.slvr)
    • Live Data
      • Weather
      • Stock Prices
      • Wolfram|Alpha (knowledge assistant)
    • Exporting
      • PDF & Printing
      • Soulver Studio
    • Integrations
      • Alfred & Raycast
      • macOS Services
      • URL Schemes
      • Terminal (CLI)
    • Tips & Tricks
      • Mac
      • iPad & iPhone
  • Syntax Reference
    • General
      • Operators
      • Rounding
      • Averages & Median
      • Logarithms & Roots
      • Trigonometry & Constants
      • Conditionals
      • Miscellaneous
    • Percentages
    • Units & Conversions
      • Converting Units
      • Currencies
      • Rates
      • Cooking Calculations
      • Unit Reference
      • Currency Reference
    • Dates
      • Calendar Calculations
      • Workdays & Weekdays
      • Timestamps & ISO8601
    • Time
      • Time Zone Conversions
      • Time Formats
      • Clock Time Calculations
      • Video Timecode & Frame Rates
    • Money & Finance
      • Compound Interest & Investments
      • Mortgage/Loan Repayments
  • Bases & Bitwise
  • Headings & Comments
  • Large Number Symbols
  • 🧪Experimental
    • Soulver X Series on GitHub
Powered by GitBook
On this page
  • ISO8601
  • Timestamps

Was this helpful?

  1. Syntax Reference
  2. Dates

Timestamps & ISO8601

Last updated 1 month ago

Was this helpful?

ISO8601

is an international standard for formatting dates & times, often used by databases.

Use "as iso8601" to convert into this format:

April 1, 2019 3:30pm as iso8601               | 2019-04-01T15:30:00+11:00

Use "to date" to convert into a regular date format:

2019-04-01T15:30:00 to date                   | 1 April 2019 at 3:30 pm

Timestamps

is a system for describing a moment in time, often used in programming. A timestamp is the number of seconds that have passed since the "reference date" (January 1st, 1970).

April 1, 2019 to timestamp               | 1554109200
1559740303.48 to date                    | 5 June 2019 at 11:11 pm

To get a timestamp for the present moment, use current timestamp

current timestamp                         | 1559740303.48

Millisecond timestamps

You can convert millisecond timestamps into dates as well

1733823083000 to date                         | 10 December 2024 at 8:31:23 pm

ISO8601
Unix time