date() vs timestamp()

[PrashantSangle]

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

[PrashantSangle]

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

Thanks for clearification.

Regards,

[stonecold111]

   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

[PrashantSangle]

yes.

[yoganantha321]

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

[PrashantSangle]

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

By the way thanks for response.

Regards,