https://pickwiki.org/index.php?action=history&feed=atom&title=Date_Conversion_DemystifiedDate Conversion Demystified - Revision history2026-04-28T22:14:47ZRevision history for this page on the wikiMediaWiki 1.43.0https://pickwiki.org/index.php?title=Date_Conversion_Demystified&diff=1729&oldid=prevConversion script: link fix2015-02-26T23:48:54Z<p>link fix</p>
<p><b>New page</b></p><div>[[UniVerse]]'s date conversion power is above what you can find in most databases.<br />
For example, where could you so easily create a query such as<br />
<pre><br />
LIST ORDERS WITH [[ORDER_DATE]] LIKE "...AUG 2003"<br />
</pre><br />
without having to stuff around with CAST and all kinds of other ugly constructs?<br />
<br />
In programming, dates are handled by the ICONV function, which converts from external (human-readable) format to internal format (number of days since 31 Dec 1967), and by the OCONV function, which converts from internal format to external format. These are best considered separately.<br />
* [[Date Conversion with ICONV]]<br />
* [[Date Conversion with OCONV]]<br />
<br />
This material is copyright &copy; 2003, Ray Wurlod. All rights reserved.</div>Conversion script