User Tools

Site Tools


syntax:functions:tounixtime

ToUnixTime(date)

Category: Date and Time function


Description

This function converts an EasyMorph (and Excel) date-time serial value to a Unix timestamp (the number of seconds since Jan 1st, 1970).


Arguments

ArgumentTypeDescription
dateDate or Number (date serial)An expression that results in a date-time serial value.

Return value type: Number.


Remarks

The date argument can take any value or expression that evaluates to a date serial value. Examples include:

  • A date string: #2019-12-12
  • A date serial value: 43811 (the date serial for "2019-12-12")
  • A date value created using any of the Date/Time functions that returns a date serial value.


Examples

tounixtime( 38247 )  //Returns 1095379200  (Corresponds to 2004-Sept-17.)
tounixtime( 44436.2074305556 )  //Returns 1630126722  (Corresponds to 2021-Aug-28 04:58:42.)


See also

syntax/functions/tounixtime.txt · Last modified: 2021/08/30 01:37 by craigt