Date format

Rajesh Veluchamy

Ranch Hand

Posts: 47

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

select sysdate from dual

i want the date in 1-nov-2008 instead of 01-nov-2008

Can any one help me

Thanks in advance

-Rajesh.V<br /> Software Consultant

Shailesh Chandra

Ranch Hand

Posts: 1087

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Use format masking, for example

SELECT TO_CHAR(sysdate,'FMDD-MON-YYYY') FROM DUAL

note,I haven't tested it.

Shailesh
[ November 09, 2008: Message edited by: Shailesh Chandra ]

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein

Avi Abrami

Ranch Hand

Posts: 1143

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Rajesh,
You also have the option of changing the NLS_DATE_FORMAT.

Good Luck,
Avi.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.