What to use: date or timestamp

[#1]

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

[swuehl]

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

[#3]

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