topic What to use: date or timestamp in QlikView

What to use: date or timestamp

Tue, 11 Oct 2011 10:37:38 GMT

Hi,

What is the actual difference between the date and the timestamp function.

Both seem to be able to handle the pure dates (YYYYMMDD) and time (HHMMSS) as well.

I use them just at random, but there has to be a reason why both were invented 🙂

Thanks for your feedback!

Maarten

What to use: date or timestamp

swuehl — Tue, 11 Oct 2011 11:04:20 GMT

Hi Marten,

I believe you are right, there is not much of a difference if you are using format codes.

I think the only difference is if you are not using format codes, so date will use the default date format, timestamp the default timestamp format, given by SET Dateformat / Timestampformat or by OS.

Regards,

Stefan

What to use: date or timestamp

Tue, 11 Oct 2011 11:41:49 GMT

Thanks, and probably - related to performance - the choice won't matter much ... I suppose ...