Re: Julian to Georgian date...HOW
>
> Does anybody know how to convert Julian date to Georgian?
>
> Thanks.
>
> --
>
create temp table t1 (julian_date char(5));
insert into t1 values ('95031');
select mdy(12,31,1900+julian_date[1,2]-1) + julian_date[3,5] units day
from t1
;
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | rzbj40@email.sps.mot.com |
+----------------------------------------------------------------------------+