nibeditas
asked on
Oracle to PL/SQL conversion
I am currently working on the conversion of PL/SQL script to T-SQL. I have certain issues that have come up correspondingly.
The To_char function in Oracle can be converted to T-sql by using convert. But Convert needs three argumemnts when date has to be converted to character.
for example:
to_char(sysdate,'dd-mon-yy yy')in Oracle can be replaced with Convert(char,getDate(),106 ). Here 106 represents the style of the date format 'dd-mon-yyyy'.
The problem is I have a pl/sql script with the following date formats:
'dd'
'MMYYHH24MISS'
I would like to know what are the corresponding Style numbers for the same in T-sql.
Thanks In Advance.
The To_char function in Oracle can be converted to T-sql by using convert. But Convert needs three argumemnts when date has to be converted to character.
for example:
to_char(sysdate,'dd-mon-yy
The problem is I have a pl/sql script with the following date formats:
'dd'
'MMYYHH24MISS'
I would like to know what are the corresponding Style numbers for the same in T-sql.
Thanks In Advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- Answered by: angelIII
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
Question has been closed as per recommendation
JGould-EE Moderator
JGould-EE Moderator
https://www.experts-exchange.com/jsp/qList.jsp?ta=mssql
https://www.experts-exchange.com/jsp/qList.jsp?ta=oracle
CHeers