current_time.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:3k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <REFENTRY ID="SQL-CURRENT-TIME">
  2.  <REFMETA>
  3.   <REFENTRYTITLE>
  4.    SQL_CURRENT_TIME
  5.   </REFENTRYTITLE>
  6.   <REFMISCINFO>SQL - Functions</REFMISCINFO>
  7.  </REFMETA>
  8.  <REFNAMEDIV>
  9.   <REFNAME>
  10.    CURRENT_TIME
  11.   </REFNAME>
  12.   <REFPURPOSE>
  13. Returns the current local time
  14.   </REFPURPOSE>
  15.  <REFSYNOPSISDIV>
  16.   <REFSYNOPSISDIVINFO>
  17.    <DATE>1998-04-15</DATE>
  18.   </REFSYNOPSISDIVINFO>
  19.   <SYNOPSIS>
  20.    CURRENT_TIME 
  21.   </SYNOPSIS>
  22.   
  23.   <REFSECT2 ID="R2-SQL-CURRENT-TIME-1">
  24.    <REFSECT2INFO>
  25.     <DATE>1998-04-15</DATE>
  26.    </REFSECT2INFO>
  27.    <TITLE>
  28.     Inputs
  29.    </TITLE>
  30.    <PARA>
  31. None.
  32.    
  33.   </REFSECT2>
  34.   
  35.   <REFSECT2 ID="R2-SQL-CURRENT-TIME-2">
  36.    <REFSECT2INFO>
  37.     <DATE>1998-04-15</DATE>
  38.    </REFSECT2INFO>
  39.    <TITLE>
  40.     Outputs
  41.    </TITLE>
  42.    <PARA>
  43.        <VARIABLELIST>
  44. <VARLISTENTRY>
  45.  <TERM>
  46.   <replaceable>time</replaceable>
  47.  <LISTITEM>
  48.   <PARA>
  49.   <ReturnValue>Returns "<replaceable class="parameter">now</replaceable>"</ReturnValue>
  50.    </VARIABLELIST>
  51.   </REFSECT2>
  52.  </REFSYNOPSISDIV>
  53.  
  54.  <REFSECT1 ID="R1-SQL-CURRENT-TIME-1">
  55.   <REFSECT1INFO>
  56.    <DATE>1998-04-15</DATE>
  57.   </REFSECT1INFO>
  58.   <TITLE>
  59.    Description
  60.   </TITLE>
  61.   <PARA>
  62.    The niladic CURRENT_TIME function has a data type of
  63.    TIME and returns the local time when it is run.
  64.   </PARA>
  65.   
  66.   <REFSECT2 ID="R2-SQL-CURRENT-TIME-3">
  67.    <REFSECT2INFO>
  68.     <DATE>1998-04-15</DATE>
  69.    </REFSECT2INFO>
  70.    <TITLE>
  71.     Notes
  72.    </TITLE>
  73.    <PARA> Refer to the SET TIME ZONE statement for a further description
  74.     of local time.
  75.    </PARA>
  76.   </REFSECT2>
  77.   
  78.  <REFSECT1 ID="R1-SQL-CURRENT-TIME-2">
  79.   <TITLE>
  80.    Usage
  81.   </TITLE>
  82.   <PARA>Display CURRENT_TIME:
  83.   </PARA>
  84.   <ProgramListing>
  85.    SELECT CURRENT_TIME AS now;
  86.    now
  87.    -----------
  88.    17:41:31+02
  89.   </ProgramListing>
  90.  </REFSECT1>
  91.  
  92.  <REFSECT1 ID="R1-SQL-CURRENT-TIME-3">
  93.   <TITLE>
  94.    Compatibility
  95.   </TITLE>
  96.   <PARA>
  97.   </PARA>
  98.   
  99.   <REFSECT2 ID="R2-SQL-CURRENT-TIME-4">
  100.    <REFSECT2INFO>
  101.     <DATE>1998-04-15</DATE>
  102.    </REFSECT2INFO>
  103.    <TITLE>
  104.     SQL92
  105.    </TITLE>
  106.    <PARA>
  107.     SQL92 specifies some additional capabilities for CURRENT_TIME:
  108.    </PARA>
  109.    <VARIABLELIST>
  110.     <VARLISTENTRY>
  111.      <TERM>
  112.      </TERM>
  113.      <LISTITEM>
  114.       <PARA>
  115.        <VARIABLELIST>
  116. <VARLISTENTRY>
  117.  <TERM>
  118.   <ReturnValue>
  119.    CURRENT_TIME [ (<replaceable class="parameter">scale</replaceable>) ]</ReturnValue>
  120.  </TERM>
  121.  <LISTITEM>
  122.   <PARA>
  123.    The optional scale for CURRENT_TIME, if specified, is an
  124.    unsigned integer representing the number of digits in the
  125.    optional seconds fraction of the time value represented
  126.    by the function.
  127.   </PARA>
  128.  </LISTITEM>
  129. </VARLISTENTRY>
  130.        </VARIABLELIST>
  131.      </LISTITEM>
  132.     </VARLISTENTRY>
  133.    </VARIABLELIST>
  134. </REFENTRY>
  135. <!-- Keep this comment at the end of the file
  136. Local variables:
  137. mode: sgml
  138. sgml-omittag:t
  139. sgml-shorttag:t
  140. sgml-minimize-attributes:nil
  141. sgml-always-quote-attributes:t
  142. sgml-indent-step:1
  143. sgml-indent-data:t
  144. sgml-parent-document:nil
  145. sgml-default-dtd-file:"../reference.ced"
  146. sgml-exposed-tags:nil
  147. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  148. sgml-local-ecat-files:nil
  149. End:
  150. -->