dt_julian_to_ansi (public)

 dt_julian_to_ansi julian_date

Defined in packages/acs-datetime/tcl/acs-datetime-procs.tcl

Parameters:

julian_date (required)

Returns:

julian_date formatted as "yyyy-mm-dd"

Testcases:

dt_julian_to_ansi

Source code:

    return [clock format [clock scan $julian_date -format %J] -format %Y-%m-%d]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="dt_julian_to_ansi.julian_to_ansi">
    <querytext>
      
    select to_char(to_date(:julian_date,'J'),'yyyy-mm-dd') 
      </querytext>
</fullquery>

packages/acs-datetime/tcl/acs-datetime-procs.xql