Hi All, I have a large number of MS SQL views to change from MS SQL to Oracle. This is fairly simple apart from each view contains a huge number of datepart functions.
I am aware that the powerful to_char function can be used as an equivalent function to the MS SQL datepart function however it would be far quicker to simply use an oracle function that is an equivalent of the datepart function. It would be great not to have to re-invent the wheel.... Is there an Oracle version of datepart available? Any help would be great. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
