Changing timezone of a timestamp field

Asked By silver joson 20 points N/A Posted on - 03/10/2012

I am working as a database administrator.

I have less experience on this field.

I want to ask like how we can change time zone of a timestamp field.

Please explain.

Thank you

Answered By Kanhai Else 0 points N/A #101465

Query to insert data into a Time Stamp field

SQL> INSERT INTO table_dt VALUES(3, TIMESTAMP '2003-01-01 00:00:00 US/Pacific');

Query to Alter a Time Zone of a session.

SQl> ALTER SESSION SET TIME_ZONE='-7:00';

Query to update the Time Zone of a Field WITH PRIMARY KEY(ID)=000

SQl> UPDATE TABLE XYZ SET T_ZONE= TIMESTAMP '2003-01-01 00:00:00 US/Pacific' WHERE ID=000;

Details of Time Stamp and Zone are given Below.

TIMESTAMP Datatype

The TIMESTAMP datatype is an extension of the DATE datatype.

Specify Syntax

TIMESTAMP [(fraction_second_precision)]

fraction_second_precision is optional

Specify the TIMESTAMP literal in a format

TIMESTAMP 'YYYY-MM-DD HH24:MI:SS.FF'

TIMESTAMP WITH TIME ZONE Datatype

TIMESTAMP [(fraction_second_precision)] WITH TIME ZONE

fraction_second_precision is optional and specifies the number of digits in the fractional part of the SECOND date time field.

Questions
0

Answers
56

Best Answers
8

Nokia OVi suite gives error