Time and Date

Note

Date variables in a GAUSS dataframe store dates in Posix format, so all “posix” functions work with GAUSS date variables.

Conversion and formatting

asDate

Converts columns of matrices, string arrays or dataframes to dates, with the option to specify the display format.

dttoposix

Converts DT scalar format to POSIX date/time format.

dttostr

Converts a matrix containing dates in DT scalar format to a string array.

dttostrc

Converts a date in DT Scalar format into a string array.

etstr

Converts elapsed time in hundredths of a second to a string, with days, minutes, hours and seconds.

posixtostrc

Converts a date in Posix time (seconds since the Epoch) into a string array.

strtodt

Converts a string array of dates to a matrix in DT scalar format.

strctodt

Converts string dates to a matrix containing dates in DT Scalar date/time format.

strctoposix

Converts string dates to a matrix containing dates in Posix date/time format.

Sequences

seqaDT

Creates a sequence of dates in DT scalar format.

seqaPosix

Creates a sequence of dates in Posix date/time format.

Differences and arithmetic

etdays

Difference between two times, as a 4x1 date vector returned by date, in days.

ethsec

Difference between two times, as a 4x1 date vector returned by date, in hundredths of a second.

hsec

Returns elapsed time since midnight in hundredths of a second.

timeDeltaDT

Adds (or subtracts) time to a DT scalar.

timeDeltaPosix

Adds (or subtracts) time to a posix date-time.

timeDiffDT

Computes the difference between two dates in DT scalar format.

timediffposix

Computes the difference between two dates in Posix date/time format.

Current time and date

dttime

Creates a matrix in DT scalar format containing only the hour, minute, and second. The date information is zeroed out.

todaydt

Returns system date in DT scalar format. The time returned is always midnight (00:00:00), the beginning of the returned day.

timedt

Returns system date and time in DT scalar format.

Other

DTV Date Time Vectors

date

Returns current system date in a 4x1 vector.

datestr

Formats a 4x1 date vector, as returned by date, as mm/dd/yy.

datestring

Formats a 4x1 date vector, as returned by date, as mm/dd/yyyy.

datestrymd

Formats a 4x1 date vector, as returned by date, as yyyymmdd.

dayinyr

Returns the day of year as an integer from a 3x1 or 4x1 vector as returned by date.

dayofweek

Returns the day of week as an integer from from a 3x1 or 4x1 vector as returned by date.

dttodtv

Converts DT scalar format to DTV vector format.

dtvnormal

Normalizes a date and time (DTV) vector.

dtvtodt

Converts DTV vector format to DT scalar format.

time

Returns current system time as a 4x1 vector.

timestr

Formats time as hh:mm:ss

UTC functions

These functions are generally not recommended, because they will make adjustments based on your current time zone.

dttoutc

Converts DT scalar format to UTC scalar format.

dtvtoutc

Converts DTV vector format to UTC scalar format.

timeutc

Returns the number of seconds since January 1, 1970 Greenwich Mean Time.

utctodt

Converts UTC scalar format to DT scalar format.

utctodtv

Converts UTC scalar format to DTV vector format.

Other DT scalar functions

dtdate

Combines separate scalars or vectors representing year, month, day, hour, minute, second to create a matrix in DT scalar format.

dtday

Creates a matrix in DT scalar format containing only the year, month, and day. Time of day information is zeroed out.