topic Re: Change DateTime to Time in QlikView

Change DateTime to Time

Anonymous — Wed, 01 May 2013 09:58:40 GMT

Hi, I'm newish to QV

I've loaded in data via Sql 2008 and QVD files. One column has the datetime data type (im not allowed to change anything in the SQL DWH) i need to change it ro just Date in the QV.

What's the best and easiest way to do this.

Thanking you guys in advance.

Re: Change DateTime to Time

er_mohit — Wed, 01 May 2013 10:06:10 GMT

date(Datetime,'DD-MM-YYYY') as Date

For Time

Time(Datetime,'hh:mm:ss') as time

Re: Change DateTime to Time

Gysbert_Wassenaar — Wed, 01 May 2013 10:06:55 GMT

Use the floor function to cut of the time part: floor(MyTimestamp) as MyDate

Re: Change DateTime to Time

Wed, 01 May 2013 10:14:13 GMT

If you change the format of date field, then try this

date(datetime,'DD/MM/YYYY')

now if you want to change its name then,

datetime as Date

Re: Change DateTime to Time

vivientexier — Wed, 01 May 2013 10:15:13 GMT

Hi,

Format or Value !

This 2 anwsers are corrects but the restult is different. You need to understand the difference.

Er.mohit give you a solution to change your field format. QlikView will present you a Date format but the value will still be a timestamp (date & time).

Gysbert Wassenaar change your field value from a timestamp to a date (no more time).

Re: Change DateTime to Time

Anonymous — Wed, 01 May 2013 10:17:56 GMT

Where do i add this?

date(Datetime,'DD-MM-YYYY) as Date

SQL

SELECT column_that_needs_changing(Datetime,'DD-MM-YYYY) as Date,

Thanks, nearly there

Re: Change DateTime to Time

Wed, 01 May 2013 10:20:35 GMT

in your script

where your clumn name present

example

load a,

date(Datetime,'DD-MM-YYYY) as Date

from..

write this

Re: Change DateTime to Time

Anonymous — Wed, 01 May 2013 10:43:58 GMT

Thanks guys.

Re: Change DateTime to Time

er_mohit — Wed, 01 May 2013 10:45:59 GMT

if your problem is resolved then you have to mark it either correct or helpful answer to closed this thread.so that it might be helpful for other developer.

Regards

Mohit