Vishal Chaturvedi
What is the difference between datetime and timestamp type?
By Vishal Chaturvedi in Databases & DBA on Mar 16 2015
  • Thiruppathi R
    Jun, 2016 1

    Refer this https://msdn.microsoft.com/en-us/library/ms182776.aspx

    • 0
  • Keerthi Venkatesan
    Apr, 2016 20

    both has same format "YYYY-MM-DD HH:MM:SS" . on storage date time takes 8 bytes and time stamp takes 4 bytes. Then major difference is the date time is what westore is what we get but in time stamp effected by the server timezone setting.

    • 0
  • Vishal Chaturvedi
    Mar, 2015 16

    The supported range for DATETIME type is ‘1000-01-01 00:00:00' to ‘9999-12-31 23:59:59', where as the supported range for TIMESTAMP type is ‘1970-01-01 00:00:01' UTC to ‘2038-01-19 03:14:07' UTC.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS