|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
query to find next saturday! - solved it
ok i have a table with match fixtures, i need to use a query that will let me see if there are any matches for the next saturday. (i know i can do where date < "29-jan-05'
BUT i need a more sophisticated query that will work ANY TIME, ie it will return the result for next saturday whenever it is ran? never mind! i used "where date = last_day(sysdate,'saturday')! Last edited by paulh1983 : January 27th, 2005 at 10:25 PM. Reason: Solved it |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > query to find next saturday! - solved it |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|