That is the right idea, but it is not returning the correct julian for us. This one returns 2455167 for the date I posted and we should be seeing 76,317.
Thanks! On Fri, Dec 3, 2010 at 11:53 AM, Gopakumar Pandarikkal <[email protected]> wrote: > You mean converting to julian date format? > To_number(to_char("1-jan-10","J")) > Hope this helps > > regards > Gopa > > On Dec 3, 2010 9:42 PM, "Ronnie Smith" <[email protected]> wrote: > > I am needing some guidance on manipulating a date field. > > I am working on creating a view and in this view I have a date field > in the format of 12/1/2009 9:40:49 AM. I am needing to convert this > field to a integer and then add 36163 and return the results in this > field on my view. I have been trying to google some info and don't > seem to be having any luck with it. Anyone have any suggestions that > might help me with this? It probably is something simple that I am > overlooking since it is Friday and the weekend is almost here. > > Thanks! > > -- > Ronnie D Smith Jr > IT Department > Rose Acre Farms > Phone (812) 497-2557 ext 290 > [email protected] > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- Ronnie D Smith Jr IT Department Rose Acre Farms Phone (812) 497-2557 ext 290 [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
