What is the difference between standard utc and dates with an appended '+00:00'

Question

Is there any significant difference between these two formats?? I am trying to keep a consistent format throughout my table so I can compare the dates later on.

first fomrat 2014-02-05 00:00:00+00:00

second format 2014-02-05 00:00:00

Answer 1

This just indicates the timezone offset. +00:00 is used to indicate no offset.

To save a date from Australia you might save the date as 2014-02-05 00:00:00+06:30