Im using Access to access a SQL database. For one of the queries i see the following under column:
{ fn month(dbo.TableName.Date) }
Ive never used this structure before but im confused to what it is? Can anyone explain please?
Thanks
The curly braces and 'fn' server to denote a OBDC level function.
The T-SQL equilivent would be:
|||
month( YourDateColumn )
Hello
Thanks for that. Could you explain a bit more on that please? As far as im concerned i didnt think there would be an ODBC link as it was connecting straight to a SQL database (checking ODBC theres no link to a SQL database either). Maybe an example if you can on what this user could have been trying to achieve would be great?
Thanks
No comments:
Post a Comment