OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Date Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date Problem [message #271282]

Mon, 01 October 2007 02:32

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

Hi,
my input is a date,any date 12-Apr-2007
and my out put will be two date

month first date 1-Apr-2007
and month last date 30-Apr-2007

Please help me................Which bulilt in function i use
and example---------------------

Raihan

Report message to a moderator

Re: Date Problem [message #271283 is a reply to message #271282]

Mon, 01 October 2007 02:35

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

You can look at trunc, last_day et al.
Have a look at the documentation as to their use.

http://tahiti.oracle.com

One other thing. What on earth makes you think that this is an expert question? This should be in the newbies section

[Updated on: Mon, 01 October 2007 02:36]

Report message to a moderator

Re: Date Problem [message #271285 is a reply to message #271282]

Mon, 01 October 2007 02:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why a question that can be answered with just a look at the documentation is a SQL Experts question?
Please, post your question in the appropriate forum.
Also follow other rules from OraFAQ Forum Guide.

Regards
Michel

Report message to a moderator

Re: Date Problem [message #271545 is a reply to message #271282]

Tue, 02 October 2007 00:31

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

Please help with coading...........

select ----?- from dual

Report message to a moderator

Re: Date Problem [message #271555 is a reply to message #271545]

Tue, 02 October 2007 00:54

Frank
Messages: 7901
Registered: March 2000

Senior Member

oracleproblem wrote on Tue, 02 October 2007 07:31

Please help with coading...........

select ----?- from dual

select 'Read the manual as indicated or pay more attention in class' from dual

Report message to a moderator

Re: Date Problem [message #271556 is a reply to message #271555]

Tue, 02 October 2007 00:54

Frank
Messages: 7901
Registered: March 2000

Senior Member

oh, and don't forget the semicolon or slash to execute it.

Report message to a moderator

Re: Date Problem [message #271564 is a reply to message #271545]

Tue, 02 October 2007 01:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And also read the forum guide as asked and requested.

Regards
Michel

Report message to a moderator

Re: Date Problem [message #272410 is a reply to message #271282]

Thu, 04 October 2007 23:44

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

For last_day function
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions062.htm

For trunc function
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions201.htm

Report message to a moderator

Re: Date Problem [message #272429 is a reply to message #272410]

Fri, 05 October 2007 01:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Once again feeding OP does not help him.

Regards
Michel

Report message to a moderator

Previous Topic:	print calendar
Next Topic:	problem with gp by function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 07:08:45 CST 2024