CODEWITHSUNDEEP
oracle-databaseoracle11goracle10gtimestamp-with-timezone
mohan
mohan

Reputation: 23

SYSTIMESTAMP AT TIME ZONE 'US/Pacific'

Hi the SYSTIMESTAMP AT TIME ZONE 'US/Pacific' will return 07/01/2015 2:54:27.699071 AM -07:00 but i require only 07/01/2015 2:54:27 AM i.e (MM/DD/YYYY HH12:MI:SS AM Format) in us pacific time zone

Upvotes: 2

Views: 3854

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

Use TO_CHAR with the required format model to get your desired output.

For example,

SQL> SELECT TO_CHAR(SYSTIMESTAMP AT TIME ZONE 'US/Pacific','MM/DD/YYYY HH:MI:SS AM') tm_stamp
  2  FROM dual;

TM_STAMP
----------------------
07/01/2015 03:28:04 AM

SQL>

Upvotes: 1

Related Questions