To be displayed in some format a date had to be converted to the string char or varchar2. What do you want to do with this string? Add a comment. Active Oldest Votes. There are several time zones in Europe, you must be more specific. Improve this answer. Wernfried Domscheit Wernfried Domscheit For example if you data is in UTC time zone and you want to display it in CET, then you could convert it like this: Note there is 2 hours offset in summer and 1 in winter.
Koen Lostrie Koen Lostrie 7, 2 2 gold badges 9 9 silver badges 17 17 bronze badges. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. P dD T hHmMsS , where d , h , m , and s are digit sequences for the number of days, hours, minutes, and seconds, respectively. Any sequence whose value would be zero is omitted, along with its designator.
For example: "PT3M3. However, if all sequences would have zero values then the syntax is "P0D". P yYmM , where y is a digit sequence for the number of years and m is a digit sequence for the number of months. For example: "P7Y8M". If the number of years or months is zero then it and its designator are omitted. Examples: "P7Y" , "P8M".
However, if there are zero years and zero months then the syntax is "P0Y". Improve this answer. Stefan van den Akker 6, 7 7 gold badges 41 41 silver badges 58 58 bronze badges. Rob van Wijk Rob van Wijk Jake You specify the number of digits with a trailing integer, e. But dates cannot hold fractional seconds anyway so you cannot use FF3 in this context.
Vincent G 1 1 gold badge 4 4 silver badges 20 20 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back
0コメント