SqlDateFormatString Method

Escapes a date formatting character for use in SQL DatePart statements depending on database type (Access or SQL-Server)

Syntax

Visual Basic
C#

'Declaration
 
<EditorBrowsableAttribute(EditorBrowsableState.Advanced)> 
Public Shared Function SqlDateFormatString( _ 
   ByVal value As String _ 
) As String

[EditorBrowsableAttribute(EditorBrowsableState.Advanced)] 
public static string SqlDateFormatString( 
   string value 
)

Parameters

value: The value to escape

Remarks

The string format is based on the database type set up for the particular solution. Used only when building SQL-strings using the SQL/DB function DATEPART.

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