On Wednesday 17 Sep 2003 13:50 in
<90446ee7.0309170450.2f16d9ef@posting.google.com>, wireless
(wireless200@yahoo.com) wrote:
> For example where the rec_num is 30608124143.47069519725 the above
> functions return 30608.
Unless you are logging dates around 3 A.D., I suggest you add 2000 to the
number before you apply the TO_CHAR() function.
I strongly suspect your app is not Y2K-compliant. [I haven't written that
for years!]
--
Regards,
Dave [RLU#314465]
======================================================
dwnoon@spamtrap.ntlworld.com (David W Noon)
Remove spam trap to reply via e-mail.
======================================================