topic Re: Date format problem in QlikView

Date format problem

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikss,

We are using oracle database. but in report it only fetching date part only.

but i want it in timestamp format. why it is not taking timestmp format from source

suggest me.

NVL(OL.DATE,OL.FUL_DATE) as date,

Re: Date format problem

avinashelite — Thu, 18 May 2017 14:04:12 GMT

Use the timestamp(date_feild) function

Re: Date format problem

trdandamudi — Thu, 18 May 2017 14:05:41 GMT

Can you post some sample data showing your source data and target data formats..

Re: Date format problem

stonecold111 — Thu, 18 May 2017 14:17:15 GMT

i will try this

Re: Date format problem

Anil_Babu_Samineni — Thu, 18 May 2017 14:21:46 GMT

May be some cases, It will work
TimeStamp(Date#(FieldName, 'DD-MM-YYYY'))

Date(Date#(FieldName, 'DD-MM-YYYY'),'DD-MM-YYYY hh:mm:ss')

Re: Date format problem

avinashelite — Thu, 18 May 2017 14:23:43 GMT

Try like

timestamp(TimeStamp#(date_feild))

Re: Date format problem

Anonymous — Thu, 18 May 2017 14:24:12 GMT

Hi Suresh,

Can you give a single example of how the datetime format is from Oracle?

e.g. is it DD-Mon-YYYY hh:mm:ss ?

Re: Date format problem

hcabrera — Thu, 18 May 2017 14:26:15 GMT

Hello,

It may be that the date field in the database is in Julian format for example 117002 which is 02 / Jan / 2017 if so you can convert it like this:

date(YearStart(MakeDate((((IWIVD - fmod(IWIVD,1000))/1000) + 1900))) + (fmod(IWIVD,1000)-1)) as date

IWIVD as date field from de oracle database.

Regards,

Henry C.

Re: Date format problem

stonecold111 — Thu, 18 May 2017 16:01:24 GMT

NVL(OL.DATE,OL.FUL_DATE) as date,

but this is sql query

what i hv to do now

Re: Date format problem

stonecold111 — Thu, 18 May 2017 16:01:39 GMT

NVL(OL.DATE,OL.FUL_DATE) as date,

but this is sql query

what i hv to do now

Re: Date format problem

avinashelite — Fri, 19 May 2017 05:37:32 GMT

Your try to convert the time format in the SQL? the check the format how its stored in the DB and convert accordingly