Home » RDBMS Server » Server Administration » Re: sysdate, to_char can anybody explain
Re: sysdate, to_char can anybody explain [message #375101] Thu, 26 July 2001 00:43
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hai deepak,
the first query,
select to_char(sysdate, 'dd') from dual;
gives you the date in the month, which is 26th in the current month.
whereas the second query.
select to_char(sysdate, 'd') from dual;
gives you the day in the week,which is 5 in your case.

Cheers,
Giridhar

Report message to a moderator

Previous Topic: transforming rows to colums
Next Topic: Re: PL/SQL Positions in Richmond, VA and Virginia Beach
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 08:04:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.