Date formats

From VistApedia
Revision as of 18:43, 9 September 2015 by Ssw0213 (talk | contribs)
Jump to: navigation, search

In VistA, dates are usually in FileMan Date Format [1]

Quoting from Hardhats.org:
  • VA FileMan's conventional internal format: "YYYMMDD.HHMMSS":
  • YYY is number of years since 1700 (hence always 3 digits)
  • MM is month number (00-12)
  • DD is day number (00-31)
  • HH is hour number (00-23)
  • MM is minute number (01-59)
  • SS is the seconds number (01-59)
This format allows for representation of imprecise dates like JULY '78 or 1978 (which would be equivalent to 2780700 and 2780000, respectively).
Dates are always returned as a canonic number (no trailing zeroes after the decimal).
  • Today's date is usually available while VistA is running in the variable DT in FileMan format.

Mumps has the $Horolog intrinsic variable [2]

  • $H[OROLOG] contains a string value specifying the number of days since "31 December, 1840,"
  • and the number of seconds since midnight of date in the time zone of the process, separated by a comma (,)

And Linux has a date command.

GTM>W ! ZSYstem "date" Write "$Horolog="_$H,!,"DT=",DT  

Wed Sep  9 14:29:32 EDT 2015
$Horolog=63804,52172
DT=3150909

--Sherlocksfriend (talk) 12:33, 9 September 2015 (MDT)