[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/04/2009 at 06:59AM PST, ID: 24871000 | Points: 125
[x]
Attachment Details

Oracle Timezone formatting

Asked by bdorsey63 in Oracle Database, PL / SQL, Oracle 11.x Database

Tags: Oracle

Oracle 11i

I would like to have the field_name_date_time display for the Central Daylight Time. Currently, the time/date data in the field is set to UTC. (I cannot and do not want to change the database, just what is displayed on the output.)

I tried setting the time zone but I cannot figure out the syntax.

How can I handle this? What is preferred?

 select field_name_1, TO_CHAR(field_name_date_time,'MM/DD/YYYY HH24:MI:SS') "field_name_date_time", TO_CHAR(field_name__elapsed_time / 60000 ) "Minutes" from table_view_v where field_name_1 = 'my name'
 
 where
 field_name_date_time type is a timestamp field
 field_name__elapsed_time type is a integer and the time is in milliseconds
[+][-]11/04/09 07:06 AM, ID: 25740026

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 07:10 AM, ID: 25740072

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 07:39 AM, ID: 25740394

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/04/09 09:07 AM, ID: 25741476

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/10/09 11:42 AM, ID: 25788956

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/10/09 11:45 AM, ID: 25788979

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/14/09 05:53 PM, ID: 25823288

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/19/09 01:55 AM, ID: 25858913

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625