Oracle to PL/SQL conversion
Posted on 2002-05-02
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.
to_char(sysdate,'dd-mon-yyyy')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:
I would like to know what are the corresponding Style numbers for the same in T-sql.
Thanks In Advance.