user3024635
Reputation: 89
How to convert this Oracle statement to T-SQL
How do I convert the below code to T-SQL ?
to_number(to_char(add_months(trunc(SYSDATE),4),'mm'))
Upvotes: 1
Views: 54
Answers (1)
Rodrigo Werlang
Reputation: 2176
month(dateadd(MONTH, 4, getdate()))
Test it with SELECT month(dateadd(MONTH, 4, getdate())) and you will have as a result the number of the month (now plus 4)
Upvotes: 1
Related Questions
- SQL query from Oracle SQL to T-SQL
- Microsoft T-SQL to Oracle SQL translation
- What would the following SQL Server statement be in Oracle
- Oracle to T-SQL conversion. How can I make this work?
- Convert query from Oracle to SQL server
- Convert SQL Server / T-SQL query to Oracle PL/SQL
- sql server to oracle query conversion
- Translating a query from Oracle into TSQL
- Converting a query from Oracle PL/SQL to Microsoft T-SQL
- How to convert this t-sql script?