sql server 2000 fn function?

microsoft.public.sqlserver.programming

22 Jun 2006 7:10 PM

nick

I just found that the following code on my SQL Server 2000. And it works
fine. what's { fn .... }?

SELECT GETDATE() AS date, { fn SECOND(GETDATE()) } AS sec

22 Jun 2006 7:25 PM

Arnie Rowland

OBDC functions.

See 'Functions for Expressions' in BOL

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

Show quote

"nick" <n***@discussions.microsoft.com> wrote in message
news:699AAE95-230B-4931-A16F-C5C3338B1273@microsoft.com...
>I just found that the following code on my SQL Server 2000. And it works
> fine. what's { fn .... }?
>
> SELECT GETDATE() AS date, { fn SECOND(GETDATE()) } AS sec