Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2011-12-30 : 23:30:39
|
| i need to convert sql format stored procedure into oraclei am writing openquery formatsome of sql server date format functions i need to convert oracleEX:DATEDIFF(DD,GETDATE(),ABC.CLAIM_EXPIRY_DATE) as"Days to Maturity",SQL SERVER 1 DATEDIFF 2 GETDATE() 3 DATEPART() 4 LTRIM() 5 COLUMN1 + COLUMN2 (ADDITION)pls provide the solution of functioality of sql server andfunctions |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-12-30 : 23:39:31
|
since you are asking about question on Oracle, shouldn't you post this in a Oracle forum ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Date functions in oracle compare to sqls server