| From: | tomg(at)sqlclinic(dot)net |
|---|---|
| To: | Postgres SQL List <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | What day is it - when it isn't NOW()? |
| Date: | 2003-08-01 18:27:05 |
| Message-ID: | Pine.LNX.4.44.0308011423030.28566-100000@q8.nrnet.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
SELECT to_char(now(), 'Day'); returns Friday as I'd hoped.
But how do I return the day of the week for a specific date other
than now()? I'm looking for something along the lines of:
SELECT to_char('2003-08-04', 'Day') without much success.
Can anyone point me to the right function/combination of functions
to achieve this?
Thanks!
-----------------------------------------------------------------------
Thomas Good e-mail: tomg(at)sqlclinic(dot)net
Programmer/Analyst phone: (+1) 718.818.5528
Residential Services fax: (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359
// Welches ist das groessere Verbrechen?
// Massenvernichtungswaffen besitzen oder sie erfinden?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-08-01 18:28:11 | Re: What day is it - when it isn't NOW()? |
| Previous Message | Jamie Lawrence | 2003-08-01 17:02:42 | Re: Fwd: Bad Join moment - how is this happening? |