On Wednesday 17 Sep 2003 13:50 in
<[EMAIL PROTECTED]>, wireless
([EMAIL PROTECTED]) 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]
======================================================
[EMAIL PROTECTED] (David W Noon)
Remove spam trap to reply via e-mail.
======================================================
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
