Home » SQL & PL/SQL » SQL & PL/SQL » Date Conersion From UTC to EST (Oracle10g)
Date Conersion From UTC to EST [message #645952] Thu, 17 December 2015 00:06 Go to next message
ssyr22
Messages: 38
Registered: December 2015
Location: PUNE
Member
How to convert date from UTC to EST my date format is '2015-12-15' I have to convert it into EST date format
Re: Date Conersion From UTC to EST [message #645954 is a reply to message #645952] Thu, 17 December 2015 00:18 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Subtract 5 hours from UTC time and you'll get EST (as it is 5 hours behind UTC).
Re: Date Conersion From UTC to EST [message #645956 is a reply to message #645952] Thu, 17 December 2015 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

SQL> with
  2    data as (
  3      select to_timestamp_tz('2015-12-15 UTC','YYYY-MM-DD TZR') dt from dual
  4    )
  5  select dt, dt at time zone 'EST' estdt
  6  from data
  7  /
DT                             ESTDT
------------------------------ ------------------------------
15/12/2015 00:00:00.000 UTC    14/12/2015 19:00:00.000 EST

Re: Date Conersion From UTC to EST [message #645957 is a reply to message #645956] Thu, 17 December 2015 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

And forget to repeat: feedback and thank people who help you, so review your previous topics and do it.

Re: Date Conersion From UTC to EST [message #645964 is a reply to message #645956] Thu, 17 December 2015 03:02 Go to previous messageGo to next message
ssyr22
Messages: 38
Registered: December 2015
Location: PUNE
Member
The given query does not work here..it gives me error Given Timezone % not Found
Re: Date Conersion From UTC to EST [message #645970 is a reply to message #645964] Thu, 17 December 2015 04:01 Go to previous messageGo to next message
ssyr22
Messages: 38
Registered: December 2015
Location: PUNE
Member
Thank to all ...who helps me...
Re: Date Conersion From UTC to EST [message #645986 is a reply to message #645964] Thu, 17 December 2015 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ssyr22 wrote on Thu, 17 December 2015 10:02
The given query does not work here..it gives me error Given Timezone % not Found


use SQL*plus and copy and paste your session.
Don't forget to format it as we did when we post for you.

Re: Date Conersion From UTC to EST [message #645987 is a reply to message #645986] Thu, 17 December 2015 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Also ALWAYS post your Oracle version with 4 decimals.

Re: Date Conersion From UTC to EST [message #645994 is a reply to message #645952] Thu, 17 December 2015 06:26 Go to previous message
EdStevens
Messages: 1377
Registered: September 2013
Senior Member
ssyr22 wrote on Thu, 17 December 2015 00:06
How to convert date from UTC to EST my date format is '2015-12-15' I have to convert it into EST date format


"date format is purely a display issue. If your column is a DATE, then its "format" is oracle's binary format for DATE. You can display in in whatever format you choose, but that has absolutely nothing to do with UTC vs. EST.
Previous Topic: Date conversion
Next Topic: A trigger to give a 10 per cent discount to a regular customer
Goto Forum:
  


Current Time: Sat Jul 04 15:08:11 CDT 2026