FUNCTION  fMJDToGMT

Computes the String of a Modified Julian Date.

From http://serendipity.magnet.ch/hermetic/cal_stud/jdn.htm String has the format yyyy-mm-dd:hh:mm:ss.sssss
select dbo.fMjdToGMT(49987.0)

Input and output parameters

nametypelengthinoutpnum
@mjdfloat8input1
 varchar32input0