MySQL Forums
Forum List  »  Oracle

CONNECT BY in MYSQL - Help me plz!!
Posted by: Utkarsh Varma
Date: August 21, 2012 08:58AM

can i convert this in to Mysql

SELECT
count(dt)
INTO
p_days
FROM(select to_date(v_start_date, 'DD-MM-YYYY') + rownum -1 dt from dual connect by level <= to_date(v_end_date, 'DD-MM-YYYY') - to_date(v_start_date, 'DD-MM-YYYY') + 1) where to_char(dt,'fmday') not in ('sunday','saturday');

help me plz !!

Options: ReplyQuote


Subject
Views
Written By
Posted
CONNECT BY in MYSQL - Help me plz!!
3214
August 21, 2012 08:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.