DateTimeExtensionsToOracleDate Method (NullableDateTime)

Converts the specified DateTime value into a string that PL/SQL interprets as the DateTime value. If the nullable type has no value, a string containing the text "null" is returned. 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 Nullable<DateTime> value
)

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

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

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

Parameters

value: Type: SystemNullableDateTime
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 NullableDateTime. 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("LST7264BCFE_0?cpp=::|nu=.");ToOracleDate Method (NullableAddLanguageSpecificTextSet("LST7264BCFE_1?cs=&lt;|vb=(Of |cpp=&lt;|fs=&lt;'|nu=(");DateTimeAddLanguageSpecificTextSet("LST7264BCFE_2?cs=&gt;|vb=)|cpp=&gt;|fs=&gt;|nu=)");)

Parameters

Return Value

Usage Note

Reference

DateTimeExtensionsToOracleDate Method (NullableDateTime)