set-system-timezone.xql

DB Query file

Related Files

• packages/acs-lang/www/admin/set-system-timezone.xql
• packages/acs-lang/www/admin/set-system-timezone.tcl
• packages/acs-lang/www/admin/set-system-timezone.adp

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
 
  <fullquery name="sysdate">
    <querytext>
      select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS') from dual
    </querytext>
  </fullquery>

  <fullquery name="sysdate_utc">      
    <querytext>
      select to_char(current_timestamp at time zone 'UTC', 'YYYY-MM-DD HH24:MI:SS') from dual
    </querytext>
  </fullquery>
	        
</queryset>