date time issue

[ali_hijazi]

hello

I got a qvw document that is reading from Oracle database from a table that contains a column of data type date time

why when I preview the data I see the date time field showing readable dates like 5/3/2012 and not 45123 for example

should n't this field's values be shown as numbers?

Please advise

[chematos]

I think that happends when is TImestamp instead DateTime. Do you see like 5/3/2012  bringing the dates straight from Oracle but the field in Oracle is a number??

In QV you can format the data like you want so what`s the problem exactly?

[jonathandienst]

Hi

Qlikview is able to see the data type of data returned frpm an ODBC or OLEDB connection. If the data type is date, QV will display it as a date, but remember that date is a dual type, with an underlying numeric value. So 3 May 2012 has a display of 2012/05/03 (depending on your default date format), and a numeric value of 41032.

Regards

Jonathan

[#4]

Commonly this fields have timestamp format.

You can solve this with Date() function in LOAD statement.

Example:

Data:

LOAD Field1,

          Field2,

          Field3,

          Date(Field4) as DateField,

          Field5

FROM database.Table;

This way, DateField have values like 03/05/2012.

Sorry for my bad english.

Regards.-