RdmDateFormat Enumeration


The RdmDateFormat enumeration is used to store information about what format should be used when the database engine is converting dates to strings. The enumeration has three values that correspond to SQL constants: YYYYMMDD, MMDDYYYY, and DDMMYYYY, which, as their names suggest, show the order that the month, day, and year portions are displayed as well as showing the number of digits that each will use. The default is YYYYMMDD.

Note that this has no impact when dates are retrieved as.NET Framework System.DateTime objects. In that case all the normal formatting abilities apply. This also does not affect dates that are returned by a query as dates but then converted to strings by the ADO .NET data provider. This only affects dates which are converted in the SQL engine to character strings.