dt_ansi_to_julian (public)

 dt_ansi_to_julian year month day [ era ]

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

Parameters:

year (required)

month (required)

day (required)

era (optional)

this argument is obsolete and passing it to the proc will generate a warning.

Returns:

the ANSI date as Julian or -1 in the case of an invalid ANSI date argument (year less than 4713 BCE, greater than 9999 CE, or equal to 0)

Testcases:

dt_ansi_to_julian

Source code:

    if {$era ne ""} {
        ad_log warning "'era' argument is obsolete"
    }

    try {
        return [clock format [clock scan ${year}-${month}-${day} -format %Y-%m-%d] -format %J]
    } on error {errmsg} {
        ad_log warning "Cannot convert ${year}-${month}-${day} to Julian date: $errmsg"
        return -1
    }

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

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