Date format with UTC [message #681128] |
Thu, 18 June 2020 03:35 |
|
Mark70
Messages: 18 Registered: June 2020
|
Junior Member |
|
|
Hi,
I have to select the value 2019-03-25 from a date column of a table but in the following format:
2019-03-25T00:00:00.000+02:00
Hon can I get it?
Oracle 10g
Thanks!
[Updated on: Thu, 18 June 2020 03:53] Report message to a moderator
|
|
|
Re: Date format with UTC [message #681129 is a reply to message #681128] |
Thu, 18 June 2020 04:00 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You need to use appropriate format elements, for example,R19 orclz> select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ssTZH:TZM') from dual;
TO_CHAR(SYSTIMESTAMP,'YYY
-------------------------
2020-06-18 09:58:31+01:00
R19 orclz>
|
|
|
|
Re: Date format with UTC [message #681170 is a reply to message #681132] |
Mon, 22 June 2020 07:18 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
If the table column is of type DATE and not TIMESTAMP you would do the following where you would replace the function SYSDATE with the name of the column
select to_char(cast(sysdate AS TIMESTAMP WITH TIME ZONE),'yyyy-mm-dd hh24:mi:ssTZH:TZM') from dual;
2020-06-22 08:17:27-04:00
[Updated on: Mon, 22 June 2020 07:21] Report message to a moderator
|
|
|
|