471,316 Members | 988 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

need query hw to select last 3month,3 week, only friday only sysdate using dual table

Hi All,
i need query,how to select last 3 month ,last 3wek,last 3 days , this last 3 month and 3 week should be friday, using sysdate from dual table, there is no exsting table, pls any one help me.


Oct 6 '09 #1
1 2810
8,127 Expert 4TB
you need to play with TO_CHAR function.
Oct 6 '09 #2

Post your reply

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

Similar topics

1 post views Thread by Yaroslav K. Kravchishin | last post: by
3 posts views Thread by Yaroslav K. Kravchishin | last post: by
1 post views Thread by deepu03 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.