topic date time issue in QlikView

date time issue

ali_hijazi — Thu, 03 May 2012 18:37:36 GMT

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

date time issue

chematos — Thu, 03 May 2012 19:13:56 GMT

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?

date time issue

jonathandienst — Thu, 03 May 2012 19:46:19 GMT

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

date time issue

Thu, 03 May 2012 20:09:56 GMT

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.-