Asked by:

Juliana date

Question

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.

All replies

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.