| From: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | Judith Strawser <judiths(at)GTScompanies(dot)com> |
| Subject: | Equivalent of Oracle next_day function |
| Date: | 2003-10-13 23:28:45 |
| Message-ID: | 5.2.1.1.0.20031013162328.00ac3ff8@mail.gtscompanies.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Is there a postgres equivalent of Oracle's next_day() function? We have a
web-based report that lists an employee's hours from Monday (of the current
week) through the following Sunday (or sometimes the same period for the
previous week); the beginning/end dates are retrieved (in Oracle) using the
next_day function, ala:
SELECT TO_CHAR ( ( NEXT_DAY ( SYSDATE, 'MONDAY' ) - 7 ),
'MM/DD/YY' ) AS THEMONDAY FROM DUAL
What would be the simplest way to do this query in PostgreSQL?
--
David Rickard
Software Engineer
The GTS Companies
A TechBooks Company
----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------
David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2003-10-14 00:14:55 | Re: Equivalent of Oracle next_day function |
| Previous Message | Bob Jarman | 2003-10-13 18:19:52 | Off Topic |