Re: Convert the MS SQL Datepart function to Oracle

2009-07-24 Thread Thomas Olszewicki
On Jul 24, 4:18 am, V wrote: > My specific problem here is the amount of time it takes to re-arrange > each statement - if I wanted to entirely re-write the statements then > to_date would be great. > > There is one apparently on this site but I don't want to sign up to > the site:- > > http://ww

Re: Convert the MS SQL Datepart function to Oracle

2009-07-24 Thread V
My specific problem here is the amount of time it takes to re-arrange each statement - if I wanted to entirely re-write the statements then to_date would be great. There is one apparently on this site but I don't want to sign up to the site:- http://www.sswug.org/articles/guestarticle.aspx?id=26

Re: Convert the MS SQL Datepart function to Oracle

2009-07-23 Thread Arne
Hi Vlad, is there any special feature on the MS "datepart" function that Oracles "to_date" function can't do? May I don't understand the problem. Look at this page: http://www.techonthenet.com/oracle/functions/to_date.php On 23 Jul., 15:05, Vlad wrote: > Hi All, > > I have a large number of MS

Re: Convert the MS SQL Datepart function to Oracle

2009-07-23 Thread Thomas Olszewicki
On Jul 23, 10:37 am, V wrote: > Thanks Thomas but I am essentially looking for someone who has written > an oracle function called datepart that replicates the functionality > of MS SQL datepart in order to make the code conversion considerably > faster. Vlad, Sorry, don't have one... Did you loo

Re: Convert the MS SQL Datepart function to Oracle

2009-07-23 Thread V
Thanks Thomas but I am essentially looking for someone who has written an oracle function called datepart that replicates the functionality of MS SQL datepart in order to make the code conversion considerably faster. --~--~-~--~~~---~--~~ You received this message b

Re: Convert the MS SQL Datepart function to Oracle

2009-07-23 Thread Thomas Olszewicki
On Jul 23, 9:05 am, Vlad wrote: > 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 funct

Convert the MS SQL Datepart function to Oracle

2009-07-23 Thread Vlad
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