This project is read-only.

Create function fn_gregorian2julian


Please create a function called tsql.fn_gregorian2julian that converts gregorian date to julian
Attached function script and help doc templates to return once you have finished development.
Thank you in advance for you help

file attachments


adudau wrote Sep 26, 2012 at 12:04 PM


wrote Sep 26, 2012 at 10:46 PM

Associated with changeset 20682: First version of fn_gregorian2julian

wrote Sep 26, 2012 at 10:55 PM

Associated with changeset 20684: Added more detailed comment

adudau wrote Oct 2, 2012 at 1:40 PM


Thank you for working on this, great start, with few twieaks it should be ready to be added to the nexy release. I did some research about Julian/Gregorian and it seems that we are acually converting between Gregorian date and Julian Day Number, and I think it makes sense to rename the function to fn_gregorian2jdn, what do you think? Also do you mind using the templete I sent and return it along with the help doc? Thanks in advance.

wrote Feb 13, 2013 at 11:43 PM

wrote Nov 27 at 6:20 PM