By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

(select Extract(dow...))

P: 1
Hi all

Does anyone know how to subtract the day of the week (in numbers)
from the current date

i tried

....(current_date + (SELECT EXTRACT(DOW FROM current_timestamp)))

but got stupid syntax errors?
Aug 30 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
i'm afraid my english isn't good enough but writting
Expand|Select|Wrap|Line Numbers
  1. select extract(dow from '30-08-2008'::date);
  2.  
you get a number representation of saturday (ie number 6).

I'm afraid it isn't what you need because you use similar query, so if you could specify what you need.
Aug 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.