Re: Help with DATE conversion based on sessiontimezone, dbtimezone

From: Brian Peasland <oracle_dba@xxxxxxxxxxxxxxxxxxx>
Date: Fri, 28 Apr 2006 18:53:07 GMT

Have you looked at the TO_CHAR function and the datetime format masks to do your conversion?

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510

HTH,
Brian

--
===================================================================

Brian Peasland
oracle_dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
.

References:
- Help with DATE conversion based on sessiontimezone, dbtimezone
  - From: marty

Prev by Date: Re: Creating remote table thru a DB Link
Next by Date: Re: nlssort problem
Previous by thread: Help with DATE conversion based on sessiontimezone, dbtimezone
Next by thread: Re: Help with DATE conversion based on sessiontimezone, dbtimezone
Index(es):
- Date
- Thread

Relevant Pages

Re: to_char not returning day value without leading zero
... Try removing the second "FM" format mask as follows: ... HTH, ... Brian Peasland ... Remove the "nospam." ...
(comp.databases.oracle.misc)
Re: Problem Trying to Create Procedure
... Does your script have a slash immediately after the END statement above? ... HTH, ... Brian Peasland ... Remove the "nospam." ...
(comp.databases.oracle.misc)
Re: SQL dude
... HTH, ... Brian Peasland ... Remove the "nospam." ... Now pick two out of the three" - Unknown ...
(comp.databases.oracle.misc)
Re: Book contrasting Oracle and MS SQLServer?
... good books that compare/contrast the two? ... HTH, ... Brian Peasland ... Remove the "nospam." ...
(comp.databases.ms-sqlserver)
Re: How to get started with Oracle
... HTH, ... Brian Peasland ... Remove the "nospam." ... "I can give it to you cheap, quick, and good. ...
(comp.databases.oracle.server)