-
sql query
hi,
i m new in this oracle world i have one prob.regarding sql query.
here is the table
skuid unit date sites
1 10 20060804 00548
4 0 20060804 123
3 23 20060809 512
9 5 20060810 896
6 2 20060808 127
1 45 20060807 3258
1 86 20060811 6548
6 20 20060809 878
4 12 20060807 5214
ohhhhhhhhhh, its my table
and i want the output is as follows
skuid no.of sites date_0804 date_0807 ....o811
1 2 10 45 86
so on..... wrt skuid
Last edited by tsp; 09-14-2006 at 12:21 AM.
Reason: its just urgent
-
You will need to leave the date as it is in the Oracle table as this is how Oracle stores date fields... I suggest using the language you are programming in to reformat and display the date as you want it to appear. Or you can look into other database solutions like SQL Server that will allow you to store dates in multipe formats ie 1/10/2009 or January 10, 2009 etc
Hope this helps
Larry D
MS Architect Evangelist
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|