Home » Other » Training & Certification » Date Problem
Date Problem [message #271282] Mon, 01 October 2007 02:32 Go to next message
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
Re: Date Problem [message #271283 is a reply to message #271282] Mon, 01 October 2007 02:35 Go to previous messageGo to next message
pablolee
Messages: 2834
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Date Problem [message #271545 is a reply to message #271282] Tue, 02 October 2007 00:31 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Please help with coading...........


select ----?- from dual
Re: Date Problem [message #271555 is a reply to message #271545] Tue, 02 October 2007 00:54 Go to previous messageGo to next message
Frank
Messages: 7880
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
Re: Date Problem [message #271556 is a reply to message #271555] Tue, 02 October 2007 00:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
oh, and don't forget the semicolon or slash to execute it.
Re: Date Problem [message #271564 is a reply to message #271545] Tue, 02 October 2007 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And also read the forum guide as asked and requested.

Regards
Michel
Re: Date Problem [message #272410 is a reply to message #271282] Thu, 04 October 2007 23:44 Go to previous messageGo to next message
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
Re: Date Problem [message #272429 is a reply to message #272410] Fri, 05 October 2007 01:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again feeding OP does not help him.

Regards
Michel
Previous Topic: print calendar
Next Topic: problem with gp by function
Goto Forum:
  


Current Time: Sun Dec 04 02:40:43 CST 2016

Total time taken to generate the page: 0.20357 seconds