Home > database >  Why in the SQL using trunc trunc occurs is not an identifiable function?
Why in the SQL using trunc trunc occurs is not an identifiable function?

Time:10-12

The SELECT rq, ka, qymc jk2, ck2, ba1, hx1, zc2, ddf1, qt1, bz, ISNULL (jk2, 0) + ISNULL (ck2, 0)
+ ISNULL (ba1, 0) + ISNULL (hx1, 0) + ISNULL (zc2, 0) + ISNULL (ddf1, 0) + ISNULL (qt1,
0) AS hj, yj, trunc (qt1-2) AS qt2
The FROM v_yjqymx

Why the runtime trunc is not a recognized function name such a hint? Please advice. Thank you!

CodePudding user response:

When the tip?

CodePudding user response:

Essentially no this function, the oracle

CodePudding user response:

The corresponding function is essentially?

CodePudding user response:

Time with dateadd string using the convert or cast

The
reference 3 floor zrz_trade response:
that essentially a corresponding function?

CodePudding user response:

reference 4 floor seven125 response:
time with dateadd string with the convert or cast

Quote: refer to the third floor zrz_trade response:

The corresponding function is essentially?


Ok, thank you!

CodePudding user response:

Very useful

CodePudding user response:

Oracle has this function

CodePudding user response:

Exclusive function, oracle,
  • Related