What does FN mean?

Question

Post reply

What does FN mean?

slzbi

Mr or Mrs. 500

Points: 535
More actions
May 13, 2008 at 11:04 am

#71265

Hi ,
i found the following code snippet:
{ fn WEEK(Created) }
It does select the week from a date.
The fucntion week is not supported by t-sql.
only when i use the keyword FN before it is supported.
Know my question?
What does FN mean and where is the function week implemented?
regards martin

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 1

Jo Pattyn

SSC-Dedicated

Points: 32348

May 13, 2008 at 11:36 am

#814699

Seems like an ODBC-function.

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

DATEPART(WEEK, Col1)

N 56°04'39.16"
E 12°55'05.25"

slzbi Mr or Mrs. 500 Points: 535 More actions · Answer 3

slzbi

Mr or Mrs. 500

Points: 535

May 13, 2008 at 1:47 pm

#814768

is FN a synonym for datepart???

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 4

No. FN makes your connection resort to ODBC level calls and use the WEEK function and calculate the week value for created column.

It will be faster to use DATEPART(WEEK, Created) instead.

N 56°04'39.16"
E 12°55'05.25"

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 5

Peter, any idea where I can get a list of these ODBC functions?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 6

This would be a starter

http://technet.microsoft.com/en-us/library/bb630290(SQL.100).aspx

Interbase can give you some clues

http://www.ibprovider.com/eng/documentation/odbc_escape_sequences_eng.html

N 56°04'39.16"
E 12°55'05.25"