topic Re: Sybase timestamp problem in QlikView

Sybase timestamp problem

Thu, 24 Apr 2014 08:03:57 GMT

Hi,

I have problem to get timestamp field from Sybase through ODBC driver. When I select from database connection a field that is timestamp, all the rows have same timestamp 1.1.1900 0:02:18

If I look from Sybase Interactive Sql timestamps looks better, although using same ODBC driver.

Any ideas, where th problem is?

Re: Sybase timestamp problem

tresB — Thu, 24 Apr 2014 08:17:20 GMT

Let the preview be as it is. Try reloading like:

Load

Date(Floor(Timestamp#(tit_erf_daz, 'DD.MM.YYYY hh:mm:ss'))) AS date

;

Select

tit_erf_daz

From <Your data source>;

Do you get all the dates?

Re: Sybase timestamp problem

its_anandrjs — Thu, 24 Apr 2014 08:19:00 GMT

For your field in load script write a code like

Timestamp(tit_erf_daz,'DD.MM.YYYY hh:mm:ss') as tit_erf_daz

Timestamp(Timestamp#(tit_erf_daz,'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY hh:mm:ss') as tit_erf_daz

Re: Sybase timestamp problem

MK_QSL — Thu, 24 Apr 2014 08:34:08 GMT

Try below four different format in your script instead of tit_erf_daz. At least one should work..

1) Timestamp(Timestamp#(tit_erf_daz,'D.M.YYYY hh:mm:ss')) as tit_erf_daz

2) Timestamp(Timestamp#(tit_erf_daz,'D.MM.YYYY hh:mm:ss')) as tit_erf_daz

3) Date(FLOOR((Timestamp#(tit_erf_daz,'D.M.YYYY hh:mm:ss'))) as tit_erf_daz

4) Date(FLOOR((Timestamp#(tit_erf_daz,'D.MM.YYYY hh:mm:ss'))) as tit_erf_daz

Re: Sybase timestamp problem

Thu, 24 Apr 2014 08:34:37 GMT

I tried, but same result. All timestamps same.

Re: Sybase timestamp problem

PrashantSangle — Thu, 24 Apr 2014 08:40:40 GMT

Hi,

Looks like it is issue of date format.

Simply load in your report.

Then try to change format in Number tab

go to number tab->select Override setting->then select date format.

Regards,

Re: Sybase timestamp problem

its_anandrjs — Thu, 24 Apr 2014 08:45:25 GMT

Try this it definitely works

Date(FLOOR((Timestamp#(tit_erf_daz,'DD.MM.YYYY hh:mm:ss')),'DD.MM.YYYY hh:mm:ss') as tit_erf_daz

Re: Sybase timestamp problem

Thu, 24 Apr 2014 08:49:33 GMT

All suggestions tried, but result is still same.