Databridge Client Console > Customize a Data Source > Cloning an Item as a Date/Time Type

Cloning an Item as a Date/Time Type

You can use the Client Configurator to clone DMS items as relational database date/time data types. The client configurator distinguishes between date and date/time data types, even though in some cases these two types are the same. Oracle supports a single date type, which is actually a date/time type, while SQL Server has a variety of date/time data types and a date data type that has no associated time.

To clone an item as a date/time

  1. In the Explorer pane, right-click a data source and click Customize Data Source from the context menu. The Client Configurator opens.

  2. In the DMSII pane, right-click the alpha item you want to clone as a date/time and click Clone As Date And Time in the context menu.

  3. Examine the Date Data Type and Date Format entries in the Options group in the DMSII Properties pane. If necessary, modify their value by expanding the list box in their associated value column and picking the desired type.

  4. In the toolbar, click Save .

NOTE:You can clone concatenated items, merge items and collapsed groups as date/time provided that the resulting length is appropriate for a date/time value.