Post reply

Undocumented function

  • October 31, 2011 at 3:57 am

    #246006

    select {fn current_date()}

    select {fn current_time()}

    select {fn now()}

    select {fn extract(hour from getdate())}

    select {fn extract(minute from getdate())}

    select {fn extract(second from getdate())}

  • November 1, 2011 at 11:23 am

    #1401743

    Far from being undocumented functions, these are a sub-set of the ODBC canonical time functions. See MSDN Library: Language Reference: Canonical Functions.

    Can be used to build cross-Provider applications. Also supported within the OLE-DB providers.

    Thanks for bringing this up, I wasn't aware of their existance either...:-)

Viewing 2 posts - 1 through 1 (of 1 total)

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