Fiddling with dates again

8 views

Skip to first unread message

Dawn Wolthuis

unread,

Apr 12, 2012, 9:36:04 PM4/12/12

to intersystems-mv

Some people love fiddling with dates. I am not among them ;-)

Are there functions in mvbasic and sql to cast between pick and mumps
dates without putting 46385 in the source code?

I now have all of 46385 numbers removed from our code, but I am
attempting to use %ZEN.ComponentEx.schedulePane which appears to
require mumps dates. So, in SQL I thought perhaps I could use the CAST
function to go from a pick date to a mumps date. The SQL documentation
for "Casting Dates" says "Casting a date to a numeric data type
returns the $HOROLOG value for the date. This is an integer value
representing the number of days since Dec. 31, 1840. " Good deal,
that's what I want. It doesn't say it, but this must be only when
casting %Date dates, not %MV.Date dates because when I cast an
%MV.Date to a number it gives me a pick number.

So, do I have to introduce 46385 back into our code or is there an
elegant way in SQL to get a mumps date (or, better yet, a way to use
the schedulePane Zen component WITHOUT using mumps dates!!)?

Thanks for any suggestions. Obviously I can brute-force it, so it
isn't urgent. Thanks. --dawn
--
Dawn M. Wolthuis