Re: to_char syntax

From: "Randy Harris" <randy@xxxxxxxxxxxx>
Date: Thu, 23 Feb 2006 04:09:06 GMT

"Liz J" <thejordanschangethistoanatsignclara.net> wrote in message
news:1140653404.29042.0@xxxxxxxxxxxxxxxxxxxxx

Hi

Could someone help me with some syntax?

I know that

SELECT To_char (sysdate, 'ddth Month YYYY')

will give me the format I want if it is today's date that I need.

But suppose it is another date that I know - say 3rd February 2006?

I can't get the syntax right.

thanks

Liz

How about:

To_char ('03-Feb-2006', 'ddth Month YYYY')

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

.

Follow-Ups:
- Re: to_char syntax
  - From: Martin Doherty

References:
- to_char syntax
  - From: Liz J

Prev by Date: Hai is there any way to find the list of top 5 employees salary
Next by Date: Multiple openings for Oracle Apps modules
Previous by thread: Re: to_char syntax
Next by thread: Re: to_char syntax
Index(es):
- Date
- Thread

Relevant Pages

Re: to_char syntax
... SELECT To_char (sysdate, 'ddth Month YYYY') ... will give me the format I want if it is today's date that I need. ... I can't get the syntax right. ...
(comp.databases.oracle.misc)
to_char syntax
... SELECT To_char (sysdate, 'ddth Month YYYY') ... will give me the format I want if it is today's date that I need. ... I can't get the syntax right. ...
(comp.databases.oracle.misc)
Re: editor for direct editing of the syntax tree: possible?
... but the raw structure of lisp sources are BINARY ... So you need to have an idea of the abstract syntax, ... how to indent the source. ... since the user must format the text like in any other emacs. ...
(comp.lang.lisp)
Re: Sane Syntax
... format documents into latex. ... better syntax checking and ease of computer parsing. ... The problem is actually not that XML itself is hard to write, but that current XML editors don't tackle this problem yet. ... If you come up with one, please consider presenting it at next year's Balisage (Montreal -- the successor to Extreme Markup) where there are *lots* of people interested in this kind of thing. ...
(comp.text.tex)
Re: Using excel through vbscript
... > Set wkbk = oxl.activeworkbook ... >> format the text file into different col. ... >> If I open file the way you told me It simply opens the text file but it does ... >>> The correct syntax would be ...
(microsoft.public.excel.programming)