<?xml version="1.0" encoding="windows-1252"?>
<node id="189993" title="Re: Shorter Formating?" created="2002-08-14 01:12:57" updated="2005-06-04 03:28:08">
<type id="11">
note</type>
<author id="132180">
screamingeagle</author>
<data>
<field name="doctext">
well, i'm only being half-serious here :0)
&lt;Br&gt;
if you're using Oracle as a back-end :
&lt;code&gt;
select to_char(sysdate,'YYYY-MM-DD HH:MI:SS') from dual;
&lt;/code&gt;

if you're using SQL Server , then it's even shorter :
&lt;Code&gt;
select getdate()
&lt;/code&gt;
can't get shorter than that, can u ? ;-) &lt;br&gt;
(I wouldnt recommend firing an sql query just to get the timestamp, though)
</field>
<field name="root_node">
189968</field>
<field name="parent_node">
189968</field>
</data>
</node>
