How to convert TSQL Datetime to Julian INT date -


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