|
|
|
| Think about Loose Coupling | |
| PerlMonks |
Re: Testing and database date functionsby iburrell (Chaplain) |
| on Dec 09, 2004 at 21:29 UTC ( [id://413691]=note: print w/replies, xml ) | Need Help?? |
|
What we do at work is use a custom function instead of current_date(). The custom function, which is implemented in PL/SQL for Oracle and PL/pgSQL for Postgres, looks in a temporary table for a test date or uses the real current date.
This allows us to set the "current date" that our SQL code sees.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||