topic Re: date() vs timestamp() in QlikView

date() vs timestamp()

PrashantSangle — Thu, 02 Apr 2015 12:35:22 GMT

Dear All,

I have read so many document about date() and timestamp()

but did not get it why we required this 2 function independently.

The reason behind asking this question is we can perfom date and time formating with date() as well as timestamp() also.

So why 2 different function available???

Which one is most preferable??

Please share knowledge

Regards

Re: date() vs timestamp()

Peter_Cammaert — Thu, 02 Apr 2015 12:42:20 GMT

True, they do not differ a lot, except that both functions default to different format strings if you omit the second parameter.

Re: date() vs timestamp()

Peter_Cammaert — Thu, 02 Apr 2015 12:44:46 GMT

Sorry, forgot about the second part of your question. I do not have a preference except that typing date takes less time (! there you have the third sister-function) than typing timestamp

Best,

Peter

Re: date() vs timestamp()

Gabriel — Thu, 02 Apr 2015 12:47:32 GMT

Hi,

Full understanding of Date is important for QV developers. I will advice to read the following blogs from HIC

The Date Function

Get the Dates Right

Automatic Number Interpretation

Re: date() vs timestamp()

PrashantSangle — Thu, 02 Apr 2015 12:51:11 GMT

Like it

Re: date() vs timestamp()

PrashantSangle — Thu, 02 Apr 2015 12:53:35 GMT

Hi,

thanks for reply.

I have already read this article but did not get the reason why 2 independent function availble in qlikview even if both perform same thing????????

Thanks again.

Regards

Re: date() vs timestamp()

vvvvvvizard — Tue, 07 Apr 2015 16:33:25 GMT

when using the date function on a timestamp you may not always get the desired output in calculations , use the timestamp when the date has a time with it eg 01/09/2015 17:23:12 and date for just dates without time

Re: date() vs timestamp()

PrashantSangle — Wed, 08 Apr 2015 05:43:21 GMT

Hi,

I dont think so the formatting is happening beacuse of date() and timestamp()

It is happening because you setting format in in load script

check your

dateFormat

and TimestampFormat in script.

Regards,

Re: date() vs timestamp()

PrashantSangle — Fri, 10 Apr 2015 11:21:08 GMT

Hi,

AnyOne??

Sir hic and Sir mby‌

please comment on this.

Regards,

Re: date() vs timestamp()

hic — Fri, 10 Apr 2015 11:31:54 GMT

dreamer4‌

You're right that both are doing the same thing. The following two calls return the same values:

Date(Time,'YYYY-MM-DD hh:mm'),

Timestamp(Time,'YYYY-MM-DD hh:mm'),

The only difference is in the defaults. The reason why it is the way it is, is mostly historical.

HIC

Re: date() vs timestamp()

PrashantSangle — Fri, 10 Apr 2015 11:58:49 GMT

Ok, I thought there might be some difference between them, which i am aware of it .

Thanks for clearification.

Regards,

Re: date() vs timestamp()

stonecold111 — Mon, 27 Mar 2017 11:41:13 GMT

Nobody has answer.. you have original name and nick name also. you respond for both

this is the same way i think.. whatever we getting results .. leave it

Re: date() vs timestamp()

PrashantSangle — Mon, 27 Mar 2017 11:50:10 GMT

yes.

Re: date() vs timestamp()

yoganantha321 — Mon, 27 Mar 2017 13:43:33 GMT

Hi Prashanth,

It is very simple concept,

Date() - it returns only the date given output

Timestamp() - it returns the date along with time duration of the given output

Example Expression:

=date(now()) --> returns 27-03-17

=timestamp(now()) --> returns 27-03-17 7:03:49 PM (as of now) ** It keeps on running

Re: date() vs timestamp()

PrashantSangle — Mon, 27 Mar 2017 14:44:48 GMT

Just read entire thread. Hope you get what I am looking for.

By the way thanks for response.

Regards,