FCFL.NET Common Library - API Reference
FormatDateLiteral Method (DbProvider)

The DateTime value to convert
Converts a DateTime value to a string according to the specific format of the underlying database type
Syntax
'Declaration
 

Public MustOverride Function FormatDateLiteral( _
   ByVal value As Date _
) As String
public abstract string FormatDateLiteral( 
   DateTime value
)

Parameters

value
The DateTime value to convert

Return Value

A literal string that is compatible with the underlying database.
Remarks
The resultant string can be used directly in a SQL statement. For example, the date will be formatted as  'yyyy-MM-dd HH:mm:ss.fff' for MSSQL or a TO_DATE(yourdate, 'yyyy-mm-dd hh24:mi:ss') function call will be returned for Oracle.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

Reference

DbProvider Class
DbProvider Members

 

 

© 2010 Dovetail Software, Inc. - All rights reserved.
- Clarify, Amdocs, and related products and names are copyright and trademark of Amdocs, Inc.
- .NET, Visual Studio.NET, C#, Visual Basic and related products are trademark of Microsoft corporation.

Send comments on this topic.