Date Conversion Demystified

From Pickwiki
Jump to navigationJump to search

UniVerse's date conversion power is above what you can find in most databases. For example, where could you so easily create a query such as


without having to stuff around with CAST and all kinds of other ugly constructs?

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.

This material is copyright © 2003, Ray Wurlod. All rights reserved.