Are there SQL functions to convert back and forth between these two?

TIA for the help.
-- Posted with NewsLeecher v3.0 Beta 6
-- http://www.newsleecher.com/?usenet

m***@beatles.com wrote:

Not in SQL Server. This is a hard problem because no single,
universally valid conversion between Julian and Gregorian is possible.
The answer depends on what time, place and proleptic calendar you take
as your reference point. I suggest you create your own Calendar table
to do the conversion.

The last word on all the messy details can be found here:
http://www.tondering.dk/claus/calendar.html

David Portas wrote:
Clarification: What I mean is that any conversion you choose to apply
may or may not be factually, historically or legally accurate dependent
on geography and the date in question. You can of course choose to use
a single conversion but its validity may be only theoretical.

DECLARE CURSOR intermittently failing
How do I pass a second parameter to user-defined aggregate (SQL 20
Custom number format
WHERE IN - Return NULL values
GetDate() in UDF