In addition to several replies advising to stay away from such undocumented features I did get this reply to my post on a ms newsgroup:
| Jul 14 2003, 4:02 pm show options |
| Newsgroups: microsoft.public.sqlserver.programming |
| From: "Anith Sen" <a...@bizdatasolutions.com> - Find messages by this author |
| Date: Mon, 14 Jul 2003 14:59:18 -0500 |
| Local: Mon,Jul 14 2003 3:59 pm |
| Subject: Re: getDate() vs {fn Now()} |
| Reply to Author | Forward | Print | View Thread | Show original | Report Abuse |
GETDATE() is a T-SQL specific function which returns the current system date
and time. The SQL standard equivalent is CURRENT_TIMESTAMP which is
applicable in T-SQL as well. The {fn Now()} is an ODBC canonical function
which can be used in T-SQL since the OLE DB provider for SQL Server supports
them. There are no notable performance difference between these though. You
can also use canonical format like :
SELECT {fn CURRENT_TIMESTAMP()} AS "date & time",
{fn CURRENT_DATE()} AS "date only",
{fn CURRENT_TIME()} AS "time only" ;