OraFAQ Forum: Server Administration » Re: How to get date (&time) in any timezone

Home » RDBMS Server » Server Administration » Re: How to get date (&time) in any timezone

Wed, 16 May 2001 04:50

Martin
Messages: 83
Registered: February 2000

Member

select TO_CHAR(sysdate, 'DD-MON-YY HH:MI AM'),
TO_CHAR(sysdate + 11.5/24 , 'DD-MON-YY HH:MI AM') as TimeZone from dual;

Previous Topic:	OCP developer. test ...please reply........
Next Topic:	MINUS function

Goto Forum:

]

Current Time: Mon Dec 23 09:33:05 CST 2024