# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
2 | 30 Apr 2008 @ 04:20 PDT | Database | Reply | Tenure in years and months between two dates | hope this helpsselect year('2008-04-30') - YEAR('2000-01-01') as years , month('2008-04-30')-MONTH('2000-01-01') as monthsThanks |
1 | 30 Apr 2008 @ 12:32 PDT | Database | Topic | How to Pass Database Name & Table Name as Input Parameter to Stored Procedure | Hi Guys,I have a requirement where I need to pass the Database Name & Table Name as input parameter to the Stored ProcedureIs this possible...Query look like thisreplace PROCEDURE ISMAIMH.GET_ITEM_... |