You are referring to ISO 8601 time, The Z suffix in the ISO 8601 time representation is sometimes referred to as "Zulu time" because the same letter is used to designate the Zulu time zone.ISO 8601 - WikipediaShould get the following.As for the extract, you need to use an expression with SQL, there ...