Re: What replaces TO_DATE in OPO Basic?
From: rob_pksa <rob_pksa_at_fox.nstn.ca>
Date: 1996/07/25
Message-ID: <4t7p0d$fkh_at_news.nstn.ca>#1/1
Date: 1996/07/25
Message-ID: <4t7p0d$fkh_at_news.nstn.ca>#1/1
In article <4t5vn7$bjk_at_wizard.pn.com>, toma_at_micrologic.com says...
>
>What replaces TO_DATE in OPO Basic??
>
>Thanks,
>Tom
Hi Tom,
Be careful with the date() function in OPO up to v1.0.16. If the user has their sysDateFormat setting at something other than the default US format of mm/dd/yy, there is a possibility of getting a reversed date -- ie, getting 09/01/96 when you wanted 01/09/96. This has been logged as bug #380783.
The workaround is to use either now() or sysDate(), both of which return the correct date regardless of the user's sysDateFormat setting.
HTH
Rob Stevenson
Dartmouth, Nova Scotia
Received on Thu Jul 25 1996 - 00:00:00 CEST