SqlDatePart Method

Returns a DatePart abbreviation for the appropriate database.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function SqlDatePart( _ 
   ByVal strPart As String _ 
) As String

public static string SqlDatePart( 
   string strPart 
)

Parameters

strPart

Return Value

Returns a string with the DatePart abbreviation, e.g. "yy" or "yyyy" etc.

Remarks

The abbreviation is based on the database type set up for the particular solution.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Database Class
Database Members