Urgent : Date Time Function

[niraj]

Can anyone tell me how this functions works with examples and how do they differ from each other ?

1. from_unixtime
2. from_utc_timestamp
   3.to_utc_timestamp