Time and Date Functions

 

DATE2DOY

Convert date series to Day of Year series

DATE2DT

Convert fractional Julian date series to date time

DATE2YMD

Convert Julian date series to years, months and days

DATEDURATION

Calculate date difference in seconds

DATEOFFSET

Add or subtract years, months, days to date values

DATEPERIOD

Calculate date difference in years, months, days

DATETIME

Convert years, months, days, hours, minutes, seconds to date time values

DAYS2HOURS

Convert days to hours

DAYS2MINUTES

Convert days to minutes

DAYS2SECONDS

Convert days to seconds

DAYS2YEARS

Convert days to years

DECDATE

Convert a decimal time series

DECTIME

Convert a decimal date series

DOY2DATE

Convert Day of Year series to date series

DT2DATE

Convert date time values to fractional Julian date values

DT2EXCEL

Convert Julian date and clock seconds to Excel timestamps

DT2TIMESTAMP

Convert Julian date and clock seconds to internal timestamps

DT2UNIX

Convert Julian date and clock seconds to Unix timestamps

DT2YMDHMS

Convert date time values to years, months, days, hours, minutes, seconds

DTDIFF

Calculate the difference of date time series in seconds

DTDURATION

Calculate date time difference in seconds

DTOFFSET

Add or subtract years, months, days, hours, minutes, seconds to date time values

DTPERIOD

Calculate date time difference in years, months, days, hours, minutes and seconds

DTSORT

Sort date time values.

DTTOIDX

Convert date time values to series indices.

DTTOX

Convert date time values to series X values

DTXY

Return the date, time and Y values of a series

EXCEL2DT

Convert a series of Excel times to Julian date and seconds

GETDT

Return the date and time values of a series

GETXDATE

Return the X coordinates in date values

GETXTIME

Return the X coordinates in time values

HMS2TIME

Convert hours, minutes, seconds to time values

HOURS2DAYS

Convert hours to days

HOURS2MINUTES

Convert hours to minutes

HOURS2SECONDS

Convert hours to seconds

HOURS2YEARS

Convert hours to years

IDXODT

Convert series indices to date time values

JULSTR

Convert a date string into a Julian integer

JULYMD

Convert a series of YYMMDD values to Julian dates

LOCAL2UTC

Convert local date time to UTC

MINUTES2DAYS

Convert minutes to days

MINUTES2HOURS

Convert minutes to hours

MINUTES2SECONDS

Convert minutes to seconds

MINUTES2YEARS

Convert minutes to years

SECONDS2DAYS

Convert seconds to days

SECONDS2HOURS

Convert seconds to hours

SECONDS2MINUTES

Convert seconds to minutes

SECONDS2YEARS

Convert seconds to years

SETXDATE

Set the X coordinates in date values

SETXTIME

Set the X coordinates in time values

STRJUL

Convert a Julian date integer to a date string

STRTOD

Convert an integer time value to a time string

STRTODMSEC

Convert a real time value with milliseconds to a time string

TIME2HMS

Convert time value to hours, minutes, seconds

TIMEDURATION

Calculate time difference in seconds

TIMEOFFSET

Add or subtract hours, minutes, seconds to time values

TIMEPERIOD

Calculate time difference in hours, minutes, seconds

TIMESTAMP2DT

Convert internal timestamps to Julian date and seconds

TODMSECSTR

Convert a time string to a real time value with milliseconds

TIMESYNC

Time synchronize two series

TODSTR

Convert a time string to an integer time value

TZCONVERT

Convert date time values to a target time zone

UNIX2DT

Convert a series of Unix times to Julian date and seconds

UNIXDT

Convert a series of Unix times to Julian date and seconds

UTC2LOCAL

Convert UTC to local date time

UTCTIMEOFFSET

Returns the time difference in seconds between local time and UTC

XTODT

Convert series X values to date time values

XYDT

Create an XY plot from the date, time and Y series

YEARS2DAYS

Convert years 2 days

YEARS2HOURS

Convert years to hours

YEARS2MINUTES

Convert years to minutes

YMD2DATE

Convert years, months, days to date values

YEARS2SECONDS

Convert years to seconds

YMDHMS2DT

Convert years, months, days, hours, minutes, seconds to date time values