DateTimeExtensionsToOracleDate Method (DateTime)

Converts the specified DateTime value into a string that PL/SQL interprets as the DateTime value. This method is often used to create text-based sql statements for data tier tests against an Oracle database.

Namespace: TestHelperExtensions
Assembly: CBI.TestHelperExtensions (in CBI.TestHelperExtensions.dll) Version: 2.1.0.1

Syntax

C++

Copy

public static string ToOracleDate(
	this DateTime value
)

<ExtensionAttribute>
Public Shared Function ToOracleDate ( 
	value As DateTime
) As String

public:
[ExtensionAttribute]
static String^ ToOracleDate(
	DateTime value
)

[<ExtensionAttribute>]
static member ToOracleDate : 
        value : DateTime -> string

Parameters

value: Type: SystemDateTime
The DateTime value for which an Oracle date value should be created.

Return Value

Type: String
A string that can be concatenated into a PL/SQL statement representing the specified date.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DateTime. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Remarks

Reminder: these methods are not recommended for use in production code, just the test of production code.

Reference

DateTimeExtensions Class

ToOracleDate Overload

TestHelperExtensions Namespace

DateTimeExtensionsAddLanguageSpecificTextSet("LST73FC8BC0_0?cpp=::|nu=.");ToOracleDate Method (DateTime)

Parameters

Return Value

Usage Note

Reference

DateTimeExtensionsToOracleDate Method (DateTime)