Date format problem

[stonecold111]

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,

[avinashelite]

Use the timestamp(date_feild) function

[trdandamudi]

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

[stonecold111]

i will try this

[Anil_Babu_Samineni]

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')

[avinashelite]

Try like

timestamp(TimeStamp#(date_feild))

[Anonymous]

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 ?

[hcabrera]

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.

[stonecold111]

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

but this is sql query

what i hv to do now

[stonecold111]

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

but this is sql query

what i hv to do now