|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 17th, 2003, 02:38 PM
|
|||
|
|||
|
Date Expression
Hi,
I am trying to get a date expression to do something at regular intervals. I can get an expression for say, the first Monday of every month: "next_day(last_day(sysdate),'mon')" or the first of every month: "last_day(sysdate)+1" The date expression I'm looking for is to specify a certain day of every month, let's say, the 16th. Can this be done? Thanks, Ben
|
|
#2
July 17th, 2003, 11:39 PM
|
|||
|
|||
|
Grab the first of the month, add fifteen and see if the current day is equal to that.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Date Expression |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
