<!--

$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.265 2005/07/14 06:17:35 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.266 2005/07/15 19:02:12 momjian Exp $

PostgreSQL documentation

-->

<row>

<entry><literal><function>date_trunc</function>(<type>text</type>, <type>timestamp</type>)</literal></entry>

<entry><type>timestamp</type></entry>

<entry>Truncate to specified precision; see also <xref

linkend="functions-datetime-trunc">

<entry>Truncate to specified precision; see also <xref linkend="functions-datetime-trunc">

</entry>

<entry><literal>date_trunc('hour', timestamp '2001-02-16 20:38:40')</literal></entry>

<entry><literal>2001-02-16 20:00:00</literal></entry>

<entry><literal><function>now</function>()</literal></entry>

<entry><type>timestamp with time zone</type></entry>

<entry>Current date and time (equivalent to

<function>current_timestamp</function>); see <xref

linkend="functions-datetime-current">

<function>current_timestamp</function>); see <xref linkend="functions-datetime-current">

</entry>

<entry></entry>

<entry></entry>

<row>

<entry><literal><function>timeofday</function>()</literal></entry>

<entry><type>text</type></entry>

<entry>Current date and time; see <xref

linkend="functions-datetime-current">

<entry>Current date and time; see <xref linkend="functions-datetime-current">

</entry>

<entry></entry>

<entry></entry>