ANSI SQL:2008: Are TRUNCATE or TRUNC a SQL Function?

Question

ANSI SQL:2008: Are TRUNCATE or TRUNC a SQL Function? Where can I find the ANSI SQL:2008?

Welcome to StackOverflow ! to get good answer you will need to improve your question. what did you do to find the answer ? please read how to ask question in Stackoverflow http://stackoverflow.com/questions/how-to-ask — Mzf, Jun 10 '13 at 17:53

maxwellb · Answer 1 · 2013-06-10T17:48:36.327

1

TRUNCATE "was officially introduced in the SQL:2008 standard."

SQL:2008 "is not freely available. The whole standard may be purchased from the ISO as ISO/IEC 9075(1-4,9-11,13,14):2008."

O'Reilly SQL in a Nutshell (ISBN-10: 0596518846, ISBN-13: 978-0596518844) lists TRUNC() as a "Platform-specific extension."

edited Jun 10 '13 at 17:48

answered Jun 10 '13 at 17:37

maxwellb

13,366
2
25
35

But the article refers to the statement (command). I want to know if there is a function with the same name. – user2471895 Jun 10 '13 at 17:41
Can you provide an example usage of either or both names? – maxwellb Jun 10 '13 at 17:43
Yes, I can. Here in this link: http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm – user2471895 Jun 10 '13 at 17:49
Got it - if you trust the folks at O'Reilly, I'd guess it's not ANSI. – maxwellb Jun 10 '13 at 17:50
You might edit the title of the Q to be more along the lines of what you're after. For example: "Is the TRUNC function in Oracle part of the ANSI SQL:2008 standard" – maxwellb Jun 10 '13 at 17:52

score 0 · Answer 2 · answered Jun 10 '13 at 17:35

0

According to the postgresql docs, yes, this is a standard command. The family of standards documents are linked to from wikipedia, but IMHO these are not very usable in their raw form. YMMV.

answered Jun 10 '13 at 17:35

PaulProgrammer

16,175
4
39
56

Thanks for your awser PaulProgrammer. But I want to know if there is a function with the same name. – user2471895 Jun 10 '13 at 17:37

ANSI SQL:2008: Are TRUNCATE or TRUNC a SQL Function?

2 Answers2