Extracting day from date

This is a discussion on Extracting day from date within the Oracle Database forums, part of the Database category; Hi Is it possible to extract the day from a given date thnx...

		Exforsys > Database > Oracle Database
Extracting day from date

Exforsys.com

LinkBack

Thread Tools

Search this Thread

#1 (permalink)

11-18-2008, 12:04 AM

shaeron_56 shaeron_56 is offline

Junior Member

Join Date: Nov 2008

Posts: 2

Extracting day from date

Hi

Is it possible to extract the day from a given date

thnx

Sponsored Links

#2 (permalink)

11-29-2008, 10:55 PM

sarunraj

Junior Member

Join Date: Nov 2006

Location: Bangalore, India

Posts: 16

hi,

select to_char(sysdate,'DAY') from dual;

this wil work.

Arun

Bookmarks

« 2-Phase locking Protocol | Why ORACLE is called ORACLE?? »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Oracle 9i tips n tricks documents for Performance Tuning	user71408	Oracle JDeveloper	1	07-15-2008 07:05 AM
Date Validation using SimpleDateFormat()	insane	Java Tutorials	0	05-05-2006 12:20 PM
Robot Competition FAQ for June 2004	R. Steven Rainwater	Tech FAQ	0	05-27-2004 08:59 PM
Comp.software-eng FAQ (Part 1): questions and answers	David Alex Lamb	Tech FAQ	0	05-23-2004 05:15 AM
comp.os.msdos.programmer FAQ part 1/5	Jeffrey Carlyle	Tech FAQ	1	04-09-2004 07:57 AM

All times are GMT -4. The time now is 09:16 PM.

Extracting day from date

Extracting day from date

Similar Threads