Oracle to SQL 2005

• ramu.guggilla

  SSC Eights!

  Points: 829

  More actions

  June 18, 2008 at 8:20 am

  #192304

  Hi folks,

  Two days back i asked the same question... but i did not get sol from any body. pleeeease leme know regarding this.

  i have some douts while converting the sp from the oracle to sql server 2005.

  what is the related in sql for the following.

  1. v_date_diff := ABS(TRUNC(p_start_date) - TRUNC(p_end_date)) + 1;

  2. v_slot_time := TO_CHAR(v_start_time, 'HH24:MI:SS');

  3. v_date_number := TO_NUMBER(TO_CHAR(v_effective_from, 'd'));

  4. v_slot_date := TO_DATE(TO_CHAR(v_effective_from, 'MM/DD/YYYY')||' '||v_slot_time, 'MM/DD/YYYY HH24:MI:SS');

  thanks in advance.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 18, 2008 at 8:34 am

  #830505

  Search google a bit.

  Here is a place to start:

  http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm