https://secure.freeside.biz/mediawiki/api.php?action=feedcontributions&feedformat=atom&user=Ryanl 2026-10-12T22:43:40Z User contributions MediaWiki 1.27.7 https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Dates&diff=2316 2007-07-09T17:27:22Z

<p>Ryanl: /* Conversion in Crystal Reports */</p> <hr /> <div>== Introduction ==<br /> <br /> Freeside stores most dates as &quot;[http://en.wikipedia.org/wiki/Unix_time Unix time]&quot; - the number of seconds elapsed since midnight UTC on the morning of January 1, 1970, not counting leap seconds.<br /> <br /> == Conversion in Perl ==<br /> <br /> * Conversion from UNIX time: see the &lt;code&gt;localtime&lt;/code&gt; function or the &lt;code&gt;Date::Format&lt;/code&gt; module.<br /> <br /> * Conversion to UNIX time: see the &lt;code&gt;Date::Parse&lt;/code&gt; or &lt;code&gt;Time::Local&lt;/code&gt; modules, among others.<br /> <br /> == Conversion in PostgreSQL ==<br /> <br /> * Conversion from UNIX time (substitute in your own time zone, date field and output field name): &lt;pre&gt;&lt;nowiki&gt;<br /> 'epoch'::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'PST' + _date_field * '1 second'::INTERVAL AS output_fieldname<br /> &lt;/nowiki&gt;&lt;/pre&gt;<br /> <br /> == Conversion in Crystal Reports ==<br /> <br /> * Download the [http://www.viksoe.dk/code/u2lwin32.htm U2lwin32 user function library]<br /> * Use the provided &quot;EpochToDateTime&quot; function<br /> * Works with Crystal Reports 11 by manually installing the U2lwin32.dll to Business Objects\Common\3.5\bin</div>

Ryanl