Field For DATETIME in BW

[Former Member]

Hi All,

I have a field with 23 characters 2006-11-01 00:00:00.000 with both time and date combined in in one field coming from Teradat into BW,i would like to create a z-field or does BW provide any field i searche for it but could not find it.

KIndly let me know how to create like data type and Routine to use to create thif field.

Thanks

Samuel

[Former Member]

Hi,

There is no standard field in BIW to represent DATETIME.

So you have 2 options now:

1) Create z info object with CHAR as data type and with length 23

2) Use one Date and one Time info objects to represent your DATETIME values.I hope, here you can use available 2 standard infoobjects.

Almost same problem in case of DB Connect for MS SQLServer is explained in the note : 512739.

With rgds,

Anil Kumar Sharma .P

Message was edited by:

Anil Kumar Sharma

[Former Member]

I have done the same and created two fields as date and time by splitting the field from Teradata.but i have to map this datetime with another system datetime and pick a field from the other system.....which will be difficult if i have two compare fields in my routine to map for a field,this the reason i was wondering if they is one datetime field in bw.

[Former Member]

Hi,

In that case you go with all 3 Info obejcts.I,e Z-infoobject (which represents DATETIME as it is) ,one DATE infoobject and One Time info object.

With rgds,

Anil Kumar Sharma .P