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.

seqaDT	Creates a sequence of dates in DT scalar format.
seqaPosix	Creates a sequence of dates in Posix date/time format.

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.

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.

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 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`

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.

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.

asDate	Converts vectors in Posix time or string dates to a GAUSS date variable and optionally sets the date display format.
dtDayName	Extracts the day from a date/time variable as a string name.
dtDayofMonth	Extracts the day of the month from a date/time variable as a decimal number (1-31).
dtDayofWeek	Extracts the day of the week from a date/time variable as a decimal number.
dtDayofYear	Extracts the day of the year from a date/time variable as a decimal number (1-366).
dtHour	Extracts the hour from a date/time variable as a number (1-12 or 1-24).
dtMinute	Extracts the minute from a date/time variable as a number (0-59).
dtMonth	Extracts the month from a date/time variable as a decimal number(1-12).
dtMonthName	Extracts the month from a date/time variable as a string name.
dtQuarter	Extracts the quarter from a date/time variable (1-4).
dtSecond	Extracts the seconds from a date/time variable as a number (0-59).
dtWeek	Extracts the week from a date/time variable as a number (0-53).
dtYear	Extracts the year from a date/time variable as a number.
getColDateFormats	Gets BSD strftime format specifiers for specified columns of a dataframe.
setColDateFormats	Specifies how GAUSS should display dates using the BSD strftime format specifiers. Note that this will also convert the type of the columns specified by column to Date.