Home » SQL & PL/SQL » SQL & PL/SQL » calendar simulation
calendar simulation [message #39721] Mon, 05 August 2002 01:38 Go to next message
SARU
Messages: 4
Registered: August 2002
Junior Member
hi
i have a table containing the dates and the day of the week.
i would like to display the output in the following format.

mon tue wed thur fri sat sun
1 2 3 4 5 6
7 8...................

any suggestions will be useful
thanks and regards.
Re: calendar simulation [message #39724 is a reply to message #39721] Mon, 05 August 2002 05:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is the date a "FULL DATE"??
i mean, dd-mon-yyyy format?
becuase we need to map the month and days...too!
if date is just a number, like 7 (7th day of month)
we need the month also!
Previous Topic: SQL*Plus returns wrong and different results for same query
Next Topic: Size of one row in table
Goto Forum:
  


Current Time: Tue Apr 23 07:04:01 CDT 2024