date query. [message #7744] |
Fri, 04 July 2003 00:01 |
Mubeen.
Messages: 37 Registered: May 2003
|
Member |
|
|
Hi Experts,
I am beginner to oracle,Currently i am facing the problem with date query.I have passed this query,and it is giving the result as below,i want the dates to be in the 19th century.
can anybody help please.
thanx in advance
Mubeen.
select to_char(hiredate,'dd/month/rrrr')from emp
TO_CHAR(HIREDATE,
-----------------
22/february /2081
02/april /2081
28/september/2081
01/may /2081
09/june /2081
09/december /2082
17/november /2081
08/september/2081
12/january /2083
03/december /2081
03/december /2081
23/january /2082
|
|
|
|
Re: date query. [message #7746 is a reply to message #7745] |
Fri, 04 July 2003 03:28 |
Mubeen
Messages: 44 Registered: February 2003
|
Member |
|
|
Dear rob,
i have passed the query as suggested by you. but still the output is same.
select to_char(hiredate,'dd/month/yyyy')from emp;
TO_CHAR(HIREDATE,
-----------------
22/february /2081
02/april /2081
28/september/2081
01/may /2081
09/june /2081
09/december /2082
17/november /2081
08/september/2081
12/january /2083
03/december /2081
03/december /2081
23/january /2082
plz reply soon.
thanx
regards,
mubeen.
|
|
|
Re: date query. [message #7757 is a reply to message #7745] |
Sun, 06 July 2003 22:47 |
roblvl
Messages: 27 Registered: June 2003
|
Junior Member |
|
|
dear mubeen,
then the date enterd into the table must have the same as displayed....
regards
rob
|
|
|
Re: date query. [message #7770 is a reply to message #7744] |
Mon, 07 July 2003 13:12 |
Larry
Messages: 11 Registered: September 2002
|
Junior Member |
|
|
Hi Mubeen,
Try this:
select to_char(hiredate,'DD-MONTH')||'19'||to_char(hiredate,'YY')from emp;
Otherwise, your real issue may be that your data has been entered into the table wrong, and you could issue an update to fix it.
Larry
|
|
|