Class Relations
- class: ::nx::EnsembleObject
::nx::EnsembleObject create ::acs::db::nsdb-postgresql::slot::__call::timezone
Methods (to be applied on the object)
add_rule (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__add_rule(:tz,:abbrev,CAST(:isdst_p AS integer),:gmt_offset,:utc_start,:utc_end,:local_start,:local_end)}]
return [ns_set value $s 0]
}
convert_to_local (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__convert_to_local(CAST(:tz_id AS integer),:utc_varchar)}]
return [ns_set value $s 0]
}
convert_to_utc (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__convert_to_utc(CAST(:tz_id AS integer),:local_varchar)}]
return [ns_set value $s 0]
}
delete (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__delete(CAST(:tz_id AS integer))}]
return [ns_set value $s 0]
}
get_abbrev (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__get_abbrev(CAST(:tz_id AS integer),:time)}]
return [ns_set value $s 0]
}
get_date (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__get_date(CAST(:tz_id AS integer),:timestamp,:format,:append_timezone_p)}]
return [ns_set value $s 0]
}
get_id (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__get_id(:tz)}]
return [ns_set value $s 0]
}
get_offset (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__get_offset(CAST(:tz_id AS integer),:time)}]
return [ns_set value $s 0]
}
get_rawoffset (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__get_rawoffset(CAST(:tz_id AS integer),:time)}]
return [ns_set value $s 0]
}
isdst_p (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__isdst_p(CAST(:tz_id AS integer),:time)}]
return [ns_set value $s 0]
}
new (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select timezone__new(:tz,:gmt_offset)}]
return [ns_set value $s 0]
}