I would like to know how to change the date in Julian Date Int to SQL,
e.g.
If my date was "01 March 2011", then how do I change it Julian Date (734197)?
declare @dateim = '20110301' dated (d, 0, dd ) + 693596
I would like to know how to change the date in Julian Date Int to SQL,
e.g.
If my date was "01 March 2011", then how do I change it Julian Date (734197)?
declare @dateim = '20110301' dated (d, 0, dd ) + 693596
Comments
Post a Comment