Converting Julian Date to MM/DD/YYYY date Format

[mohanagrawal19]

Hi All,

Is there any way that we can directly convert the Julian date to MM/DD/YYYY date format using the SQL Statement?

Thanks
Mohan

[DeadManWalks]

Re: Converting Julian Date to MM/DD/YYYY date Format

Hey, there is no Julian date function. You wuold have to use a combination of || and SubStr to accomplish.