I've got a question about Juliana Date in SQL Server 2008 R2.
when I convert Julian date to Gregorian Date, My system show the follow date 2014-09-29 but, I was testing in others machine (3) and the result change, this is 2014-09-30, this is the same in new machines. the zone time is same for all machine.
We need to verify if you define the function of converting Julian date to Gregorian date, then convert the Julian date. Or you perform the following T-SQL statement to convert date in all machines. Also we need to confirm you type the same Julian date in
SQL Server .
For example, the Julian date is 109060, you can run them to convert date.
DECLARE @jdate int
SET @jdate = 109060
select dateadd(dd, (@jdate - ((@jdate/1000) * 1000)) - 1, dateadd(yy, @jdate/1000, 0))
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.